Incorrect Percentage Calculation in Data Visualization (Time Series : Column)

Soufian AZZA
Tera Contributor

‎05-02-2025 02:25 AM

Hi everyone,

 

I’m facing an issue with a data visualization in ServiceNow. I’m using a Column Times Series chart to display true and false values by year. The count values appear correctly, but the percentages shown in the table below the chart are incorrect.

 

Capture d’écran 2025-05-02 à 11.09.03.png

 

For example, in the year 2025:

 

  • true = 9

  • false = 1

  • Total = 10

    So I would expect:

  • Percentage for true = 90%

  • Percentage for false = 10%

 

 

However, the chart displays:

 

  • Percentage for true = 75%

  • Percentage for false = 33.33%

 

 

It looks like the calculation isn’t based on the correct yearly total (true + false).

 

Has anyone encountered this issue before? Could it be a misconfiguration in the widget?

 

Thanks in advance for any help!

0 Helpfuls
  • 2,706 Views
10 REPLIES 10

Soufian AZZA
Tera Contributor

‎05-02-2025 02:35 AM

What’s strange is that when I use the classic report builder, the percentage calculations are correct. This issue seems to appear only in the new Data Visualization experience.

Capture d’écran 2025-05-02 à 11.33.20.png

 

0 Helpfuls

Robert H
Mega Sage

‎05-02-2025 02:46 AM

Hello @Soufian AZZA ,

 

You need to read the information like this:

 

You have a total of 12 records with the true value. 3 of them (25%) were in 2017, and 9 of them (75%) were in 2025.

You have a total of 3 records with the false value. 2 of them (66.6%) were in 2017, and 1 of them (33.3%) was in 2025.

 

Regards,

Robert

0 Helpfuls

Jamie Stroud
Tera Guru
In response to Robert H

‎08-21-2025 06:56 AM

Yes, the way you to describe it is the correct way to read the percentages. The problem is a) The same report displays differently in a core UI report vs the data visualization, and b) Although it's arguable, I think more people would agree the most likely way to interpret percentages in these types of reports is how core UI displays them.

mattmm
Kilo Sage

‎08-06-2025 01:32 AM

@Soufian AZZA  I've noticed this also, and like you the calculation is correct in Reports, but in Data Visualizations  whoever has coded this has incorrectly tried to code percentages on the total records, and not by the time series month or week etc. as reports did properly and successfully......I suspect this is a defect that could be logged to ServiceNow.....something else they have not done in Data Visualizations that was available in reports is when you hover over a bar it would show percentages, but now it does not do this.......Have you logged this with ServiceNow?