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!
