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?
Create a variable to the report that will contain the number of days from the initial “Case Create Date” to the current date.
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 (=””)
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])