How to Group Knowledge Ratings (1–5) in Bar Chart Report Instead of Exact Decimal Values?

JoostHW
Tera Contributor

Hi all,

I'm building a report in ServiceNow that shows a bar chart of knowledge article ratings, based on the rating field from knowledge.

Right now, the bar chart groups each exact decimal value separately, which creates too many bars. For example, I see: 

JoostHW_0-1750083536614.png

 

What I want:
I’d like to group the ratings into whole numbers from 1 to 5, so the chart shows:

  • Rating 1 → X articles

  • Rating 2 → Y articles

  • Rating 3 → Z articles

  • Rating 4 → ...

  • Rating 5 → ...

Goal: A clean, 5-bar chart overview based on rounded or bucketed ratings.

 

Thank you in advance! 

3 REPLIES 3

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @JoostHW 

 

Go to Style and make the changes here:

 

DrAtulGLNG_0-1750086359226.png

 

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

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

Hi Atul,

Thank you for your quick response, I have it at 0 but it still shows 1 decimal sadly. 

Hi @JoostHW 

I tried the same on my end, and it seems these issues are not working. It’s best to log a Now Support case.

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

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