Report for show ticket count per day grouped by category in Platform Analytics Dashboard
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 hours ago
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 hours ago
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]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
an hour ago
Can you suggest me to generate a report to see tickets on the daily basis.
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
an hour ago
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]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
59m ago
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

