Need help in Report/Dahboard

[Admin7267]

I have a requirement to show list of all incidents which are new, in progress and on hold on every Monday of 2025, irrespective of whenever the incident is created.

Consider an incident is created in December 2024 and it was resolved on Tuesday of second week 2025, the that incident has to be part of Week 1 and Week 2.

I know that it will not be possible using OOB reporting module, so I tried with Performance Analytics and it's not working for me

Data Source:

Can anyone correct me if I did something wrong or it not be feasible with Performance Analytics as well?

[Bhuvan]

@Admin7267 

You are right and on correct path. You cannot use reporting or dashboard to cater this requirement and need to use Automated Indicator to collect the scores and display the indicator in KPI Dashboard.

1. Create automated indicator [Indicator Source - Incident] to collect the data on daily basis and breakdown by state and configure daily data collection job

2. Create a KPI dashboard and show the data and use time aggregation [period - week] as per your requirement

If this helped to answer your query, please mark it helpful & accept the solution. 

Thanks,

Bhuvan

[Bhuvan]

@Admin7267 

If you are looking for count of incidents on daily basis grouped by State, consider creating a scripted indicator. Out of box automated indicator would provide the count of incidents created on TODAY but you are looking for sum of incidents for that day.

This should provide the details you are looking for i.e. count of incidents grouped by state. This is a high level guidance, adjust the indicator configuration accordingly.

If this helped to answer your query, please mark it helpful & accept the solution. 

Thanks,

Bhuvan

[kaushal_snow]

Hi @Admin7267 ,

Yes, this is possible with Performance Analytics. You need to use an automated indicator (based on the Incident table) with a filter for state IN (New, In Progress, On Hold), not filtering by creation date. Then schedule a data collection snapshot job to run every Monday. Also use the historical data collection job to backfill missing Mondays.....

Make sure you explicitly exclude resolved/closed states, and check that the snapshot is capturing the count as of each Monday. Be aware: if you drill down into snapshots, record fields like state may reflect the current state, not necessarily the state on that Monday only the count is guaranteed for snapshot time.....

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.

[MPD Odijk]

1) If you set up something in Performance Analytics, it will start to gather data per the day tat you have set it up. If you want to go back to the beginning of 2025, then you will have to explicitly ask Performance Analytics to also include historical data: https://www.servicenow.com/docs/bundle/yokohama-now-intelligence/page/use/performance-analytics/task...

2) it feels odd that each monday has the same values. Did you set PA up correctly?

Good luck!