Reporting - re-use variable

[Carl Tovey 0]

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

 

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?

 

 

[Bob Dickinson 109]

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

[Carl Tovey 0]

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