Hi,
I created a table in kibana viz with elastic version 7.6.1.
It's showing the incorrect "Count Percentage" tab in the table.
I checked the config of Table viz,but still unable to solve this.
Snap-Incorrect percentage
jsanz
(Jorge Sanz)
March 10, 2022, 4:43pm
#2
Seems you are hitting this issue
opened 06:09PM - 30 Apr 20 UTC
closed 06:31AM - 06 May 20 UTC
bug
Feature:Data Table
Team:VisEditors
**Kibana version:**
master, 7.6.2
**Describe the bug:**
There an issue with… Count percentage value rounding in Visualize Data Table. When using the default setting of `format:percent:defaultPattern`:

The **Count percentage** of products priced >= 0 ands < 11 is displayed **14.8%**

Setting it to ` 0,0.000%`, it's displayed **14.800%**

Setting it to ` 0,0.[00000]%`, it's displayed **14.771%** , that's what you'd expect when setting it to ` 0,0.000%`

This is due to internal rounding in UI in combination with the numeral formatter.
* The number, calculated in the Data Table Vis, is `0.0014771011575239054`
* It's formatted with the numeral based percent formatter and becomes `0.148%`
* Then it's formatted again and becomes `14.8%`
The mentioned issue was solved in 7.8 upwards
elastic:master
← kertal:kertal-pr-2020-04-30-fix-data-table-rounding
opened 06:44PM - 30 Apr 20 UTC
## Summary
Fixes #64939
Fixes https://github.com/elastic/kibana/issues/646… 21
Fixes an issue with Count percentage value rounding in Visualize Data Table. When using the default setting of `format:percent:defaultPattern`:

The **Count percentage** of products priced >= 0 ands < 11 in this example was displayed **14.8%** instead of **14.771**

The reason for this was that the number was formatted and rounded twice.
### Checklist
Delete any items that are not applicable to this PR.
- [x] [Unit or functional tests](https://github.com/elastic/kibana/blob/master/CONTRIBUTING.md#cross-browser-compatibility) were updated or added to match the most common scenarios
1 Like
HI @jsanz ,
Thanks for the reply.
The below format works fine for table viz.
Percent format-
0.000%
Old format/Default Format-
0,0.[000]%
1 Like
system
(system)
closed
April 7, 2022, 5:33pm
#4
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.