creating a report

mohammeda36
Tera Contributor

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.

 

1 REPLY 1

AndersBGS
Tera Patron
Tera Patron

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/