Create report in Performance anylytics

Asha Pathak
Tera Contributor

Hello Community!

 

I have requirement.

Add the Average incident resolution time for the last 6 months_ALL groups (4 group names) by PRIORITY
Use Business duration to calculate resolution time
First visual add as a bar chart with 4 bars: P1, P2, P3, P4 for the past six months combined total
Second visual add as a bar chart with 4 bars: P1, P2, P3, P4 for each month showing each of the past 6 months totals not combined.
Example February 2025 4 bars P1, P2, P3, P4 | January 2025 4 bars P1, P2, P3, P4 | December 2025 4 bars P1, P2, P3, P4 | November 2025 4 bars P1, P2, P3, P4 | October 2025 4 bars P1, P2, P3, P4 | September 2025 4 bars P1, P2, P3, P4
This should be a rolling past 6 months so that the months and total change with the start of each new month

How to calculate in PA?

Please help/1

1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Asha Pathak 

I see you're asking a lot of questions about reporting, and I'm not sure if you've tried anything yet. Please let us know what you've attempted so far and where you're getting stuck, so we can assist you better.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************