InfoSol We're passionate about inspired business intelligence
Related Articles
Question: I have a need to show dates, in a column, that fall into a certain date range (1-5 days). In the second column, show dates that fall into a second date range (6-10 days). At the bottom of each column, display a count of the dates that fall into each of the criteria. How can I accomplish this?
Answer:
Step 1
Create a variable to the report that will contain the number of days from the initial “Case Create Date” to the current date.
Step 2
Create Alerters, so that only the correct data is shown in each of the columns.
- The first Sub-Alerter will display the Case Create Date.
- The second Sub-Alerter will display a blank (=””)
Step 3
Create your count at the bottom of each column.
- =Count([Days Between])Where ([Days Between] Between(1;5))
- =Count([Days Between])Where ([Days Between] Between(6;10))
- =Count([Days Between])
Finished Report
