PA – Monthly Unique Count of Incidents Not Updated for 7+ Days

[Shark0os17]

Hi everyone,

I have an indicator that captures incidents which have not been updated for more than 7 days.

I would like to build a report that shows the monthly count of unique incidents that meet this condition.

The key point is that each incident should only be counted once per month, even if it remains inactive for multiple days within that same month.

Example:

• Incident X is not updated on 01/01, 02/01, and 03/01
• In the monthly report, it should be counted only once for January

The goal is to display a clear monthly trend of how many distinct incidents have remained inactive for more than 7 days.

Has anyone implemented something similar in PA?
What would be the best approach to ensure uniqueness per month (breakdowns, scripts, or aggregation settings)?

Thanks in advance for your help!

[AndersBGS]

Hi @Shark0os17 

I don't see this as possible in performance analytics, as the daily data collection will capture records not updated in 7 days. As an alternative, you need to have a custom field with (true/false) populated by scheduled daily script, set the field to true if month = jan and record has not been updated for 7 days. If value is true skip, otherwise set field... 

Not the best solution, but that should work.

[Shark0os17]

Hi Anders,

Thanks for your suggestion, but I cannot proceed with this approach.

Would it be possible to use the data already collected in ServiceNow Performance Analytics and use it in a standard ServiceNow report via View / Run ?

Kind Regards