I am trying to create a column with list of dates. These dates should populate in the report from values selected in the filter.
casestatus (count) | Date |
3 | 2/6/2020|
here there are two columns; one with case status count and the other is date.
we have setup a filter with case status = resolved and resolved date = previous week
i need to display all the dates of the previous week in date column as mentioned on the filter.
if the filter date range is changed, the list of dates on the date column should also change.
can someone help me with populating the dates on the report.
note: the dates with no records should also populate on the report. for instance, 1/6/2020 has 0 records, but the date should be present on the date column
In report definition , I think it is not possible to display the dates when there is no records in the list. Probably if you could use data page as bridge having report as source, then you can use the response data transform to achieve this.