How to show Individual count for each month and each state on PA report

[Aishwaryayadav6]

I created a PA report which gets data from past 12 months and I used a state breakdown so that it shows count for each state. I want to trend it by due date.  But the report shows cumulative counts of the records for 12 months, i want to display individual counts for each state on each month.


Below is the widget configuration

Below is the indicator configuration

Below is the indicator source configuration

Please suggest If anyone having idea about the solution.

Thanks in advance.

[AndersBGS]

Hi @Aishwaryayadav6 ,

 as far is I interpreted your data, then this is due to your filter on your indicator source and due to that you have run a historical job. The due date before one month ago and due date after 12 month ago will increase you data over time,  as there has come more and more tickets.

if you adjust your filter then it should mostly work.

remember also, as “open” is not a recorded date field, then it will be the same every month, as you can only take historical date collection for data where you have recorded date.