We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

Report for show ticket count per day grouped by category in Platform Analytics Dashboard

Abhi7
Giga Contributor

I'm trying to build a report in Platform Analytics (PAR) Dashboard.

 

The report should show ticket counts on per day basis, but I don't have any Date field in my table. There is only Created field which is a date/time field and hence the separation is based on time as well and there are too many data points that means at every second or every minute. Also, I want to group the tickets by category type.

 

I have used the Spline type of chart and checked the "Show Data table" checkbox to show the tickets counts on the daily basis, but it is showing one column for the percentage as well for each category type. I want to get rid of this percentage column for every category type.

 

Please help me in creating the report for my requirement.

 

Thank you

5 REPLIES 5

Dr Atul G- LNG
Tera Patron

Hi @Abhi7 

That is the expected behavior: if it shows data, it will display as a percentage. Unfortunately, by design, we cannot remove it.

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

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

Abhi7
Giga Contributor

Can you suggest me to generate a report to see tickets on the daily basis.

Thank you

Hi @Abhi7 

 

Follow screenshot

 

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

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

I followed your solution, but this is also showing Percentage column for each Category when I check "Show data table" check box.
I want to see the table with only the numbers and not the percentages.

 

Thank you