creating a report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
I need help creating a PA dashboard that shows average resolution time per Problem record (not grouped by date). The bar chart should list each Problem record individually and allow drill-down to see which state took the longest. Any guidance on which indicator/breakdown setup is required?
I would like the dashboard to have a similar layout to the snippet below. However, instead of displaying dates, it should show problem records, and instead of numbers on each bar, it should reflect the number of days.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Hi @mohammeda36 ,
Your requirement doesn't make sense. You're stating "average resolution time per Problem record". But average resolution time is per definition a sum of several resolution time where you find the average by dividing the sum by the count.
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/