Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to show zero if there is now P1 ticket on the report

Rahul Raja Sami
Tera Guru

Hi
I have created a time series report grouped by Priority. It is showing data if there are any related records and will not show it they aren't any. I want to show it as zero if there isn't any related record, how?

And I dont understand why I am not able to attach related images here? 

11 REPLIES 11

Eswar Chappa
Mega Sage

Hi @Rahul Raja Sami 

 

as per the conclusion from the below article you cannot show zero values on a line graph report in ServiceNow reports

 

https://www.servicenow.com/community/developer-forum/how-can-i-display-a-zero-count-data-point-on-li...

 

Thanks & Regards,

Eswar Chappa

Mark my answer correct and Helpful if this helps you 😀

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Rahul Raja Sami 

 

Is something you are looking for 

 

https://www.servicenow.com/community/platform-analytics-forum/displaying-0-value-in-servicenow-repor...

 

https://www.servicenow.com/community/incident-management-forum/bar-chart-report-to-show-0-zero-resul...

*************************************************************************************************************
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]

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

AndersBGS
Tera Patron
Tera Patron

HI @Rahul Raja Sami ,

 

Not possible through the report designer for a time series report, but can be done if you utilize performance analytics. Alternative, create a single score report, then it will show "0" of there is non.

 

If  my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

best regards

Anders

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/

Hi @AndersBGS , if you are talking about PA Indicator, can you help me configuring one?