Jump to content

Reporting - re-use variable


Carl Tovey

Recommended Posts

Hi

I'm trying to use a range of dates collected from one condition (date logged) in a second condition (date resolved).

I've given the variable a reference, but I can't use it in the other contion

image.png.9283041853ab0d97578e452d8c00af9b.png

 

The end result is that I'm trying to write a report that is: grouped by day, cases opened, and cases resolved, within a range of dates. Shown on a bar chart. (Case turnover)

 

Is this possible please?

 

 

Link to comment
Share on other sites

Hi @Carl Tovey

I'm not entirely sure about the "Group by day" part of your requirement and if that is actually possible. However for the part you are referencing in the screenshot, have you tried checking the "Use Existing Prompt" checkbox for the Dateresolved date? This should use just 1 date/time selector for both the inputs.

Kind Regards

Bob

  • Thanks 1
Link to comment
Share on other sites

2 hours ago, Bob Dickinson said:

Hi @Carl Tovey

I'm not entirely sure about the "Group by day" part of your requirement and if that is actually possible. However for the part you are referencing in the screenshot, have you tried checking the "Use Existing Prompt" checkbox for the Dateresolved date? This should use just 1 date/time selector for both the inputs.

Kind Regards

Bob

Missed that, thanks Bob

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...