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`:
![Bildschirmfoto 2020-04-30 um 19 52 34](https://user-images.githubusercontent.com/463851/80742818-4919e380-8b1c-11ea-9ff1-2f466d46da50.png)
The **Count percentage** of products priced >= 0 ands < 11 is displayed **14.8%**
![Bildschirmfoto 2020-04-30 um 19 59 16](https://user-images.githubusercontent.com/463851/80743352-1ae8d380-8b1d-11ea-91b9-40382b84e780.png)
Setting it to ` 0,0.000%`, it's displayed **14.800%**
![Bildschirmfoto 2020-04-30 um 20 01 16](https://user-images.githubusercontent.com/463851/80743513-613e3280-8b1d-11ea-9f1f-a58a1a574f0b.png)
Setting it to ` 0,0.[00000]%`, it's displayed **14.771%** , that's what you'd expect when setting it to ` 0,0.000%`
![Bildschirmfoto 2020-04-30 um 20 06 57](https://user-images.githubusercontent.com/463851/80743941-2dafd800-8b1e-11ea-90ba-8c610dee8ad0.png)
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`:
![Bildschirmfoto 2020-04-30 um 19 52 34](https://user-images.githubusercontent.com/463851/80742818-4919e380-8b1c-11ea-9ff1-2f466d46da50.png)
The **Count percentage** of products priced >= 0 ands < 11 in this example was displayed **14.8%** instead of **14.771**
![Bildschirmfoto 2020-04-30 um 19 59 16](https://user-images.githubusercontent.com/463851/80743352-1ae8d380-8b1d-11ea-91b9-40382b84e780.png)
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.