Calculating and Displaying Weekly Average Age of Open Incidents in Performance Analytics
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-03-2024 02:10 PM
Hello,
I’m trying to calculate the average age of open incidents on a weekly basis in Performance Analytics. I’ve created an indicator using the formula:
Summed age of open incidents / (Number of open incidents * 24).
I’ve set the collection frequency to ‘Daily’.
However, I’m having trouble getting this to work correctly as it appears to be doing a running average. I want to display the average age of open incidents for the current week (up to the current day) in my Performance Analytics dashboard. I’ve created a widget to display this data for the ‘Current week’, but it’s not showing the results as expected.
Could anyone provide some guidance on how to correctly set up this indicator and widget to display the weekly average age of open incidents so far?
Any help would be greatly appreciated!
Thank you.