Performance Analytics Reporting

Narmadha PR · 3 weeks ago

Hi, I am working on ServiceNow Yokohama. I am trying to create Performance Analytics dashboard in the following formats, but none of them seem to be possible. Is it actually possible to create a performance analytics dashboard in any of the following formats? If yes, please let me know.

Date	Measure	Percentage	Count
1/02/2025	A	100%	10
1/02/2025	B	10%	2
1/02/2025	C	45%	5
1/02/2025	D	89%	3

	Total	Option A	Option B	Option C
Total tickets	1	4	7	67
Total tickets in New state	1	2	0	56
% of tickets in new state	100%	50%	0	84%

	Total	Total tickets in New state	%	Notes
Option A	5	0	0
Option B	10	5	50%
Option C	99	1	1%	- Invalid credentials

Name	Total Tickets	Total tickets in New state	% of tickets in new state
A	3		0
B	43	38	88%
C	7	1
D	29	1	3%
E	1	1	1001%
Total	18	6	33%

Dr Atul G- LNG · 3 weeks ago

Hi @Narmadha PR

Agree not 100% you can show ,

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

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

View solution in original post

AndersBGS · 3 weeks ago

Hi @Narmadha PR ,

The short answer is no. Performance analytics is utilized for calculation and aggregation in a report widget format - not table format.

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/

View solution in original post

Dr Atul G- LNG · 3 weeks ago

Hi @Narmadha PR

Agree not 100% you can show ,

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

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

Narmadha PR · 3 weeks ago

Hi @Dr Atul G- LNG ,

Thank you for your response. Using Platform Analytics I'm unable to calculate the percentage. Do you have any idea on this?

Dr Atul G- LNG · 3 weeks ago

Hi @Narmadha PR

I think you can try creating an indicator and formatting it, or use a calculated function field in the report to see if that works for you without using Performance Analytics (PA).

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

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

Narmadha PR · 3 weeks ago

Hi @Dr Atul G- LNG,

I created 2 automated indicators with one formula indicator that calculates the percentage of the 2 automated indicators. And I've created a Data Visualisation. Now I want to calculate the percentage on monthly and weekly basis. What should be my frequency in the indicators and what aggregation should I select in the metrics of the Data Visualisation?