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.

[Aishwaryayadav6]

Hi @AndersBGS ,

Thanks for reviewing. Based on your inputs, I verified the data using the Analytics Hub → View Records option and confirmed that the data is being fetched correctly. However, the bars are not displaying the correct counts.

For example, there is only 1 “Work in Progress” case in September 2025, but the State column bar shows 37 “Work in Progress” cases — which represents the total for all 12 months in past. I’d like to display only the count for September (1) instead of the cumulative total for all months (37).

Your guidance on this would be greatly appreciated.