# Table does not show percentage when locale setting is changed

**URL:** <https://discuss.elastic.co/t/table-does-not-show-percentage-when-locale-setting-is-changed/232921>\
**Category:** Kibana\
**Created:** [May 16, 2020, 11:27am UTC](https://discuss.elastic.co/t/table-does-not-show-percentage-when-locale-setting-is-changed/232921 "2020-05-16T11:27:40Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Anabella\_Cristaldi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anabella_cristaldi/32/23612_2.png) [@Anabella\_Cristaldi](https://discuss.elastic.co/u/Anabella_Cristaldi)\
**Post date:** [May 16, 2020, 11:27am UTC](https://discuss.elastic.co/t/table-does-not-show-percentage-when-locale-setting-is-changed/232921/1 "2020-05-16T11:27:41Z")

</div>

Hi all,  
I'm doing a very simple table using a Term agg and where I want to calculate the percentage over the count column.  
Everything goes well  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/3/f3f0703bbfdfafb983431424b10fa3c6c5bea9c7.png)

But when I change in the Kibana Advanced Setting the Formating locale to

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/e/b/eb7c3ecf1beab0727b2ec33499019dd10da50e63.png)

Then the percentage column is not calculated

![image](https://us1.discourse-cdn.com/elastic/original/3X/c/d/cd25e8e77c7ecb4600315dacfac5d70405887782.png)

Thank you!  
Regards

---

<div class="post-metadata">

**Author:** ![tiagocosta](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tiagocosta/32/40045_2.png) [@tiagocosta](https://discuss.elastic.co/u/tiagocosta)\
**Post date:** [May 16, 2020, 10:01pm UTC](https://discuss.elastic.co/t/table-does-not-show-percentage-when-locale-setting-is-changed/232921/2 "2020-05-16T22:01:45Z")

</div>

@Bamieh do you think you can provide some help here please?

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [May 17, 2020, 9:10pm UTC](https://discuss.elastic.co/t/table-does-not-show-percentage-when-locale-setting-is-changed/232921/3 "2020-05-17T21:10:40Z")

</div>

We recently fixed this bug in this PR [https://github.com/elastic/kibana/pull/64948](https://github.com/elastic/kibana/pull/64948)

---

<div class="post-metadata">

**Author:** ![Anabella\_Cristaldi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anabella_cristaldi/32/23612_2.png) [@Anabella\_Cristaldi](https://discuss.elastic.co/u/Anabella_Cristaldi)\
**Post date:** [May 18, 2020, 8:40am UTC](https://discuss.elastic.co/t/table-does-not-show-percentage-when-locale-setting-is-changed/232921/4 "2020-05-18T08:40:15Z")

</div>

Thank you @tiagocosta and @wylie,

How can I add this update to my 7.7 version.  
I changed the .js

`/usr/share/kibana/src/legacy/core_plugins/vis_type_table/public/agg_table/agg_table.js`

but still not working... probably I need to do something more.

Regards  
Anna

---

<div class="post-metadata">

**Author:** ![rclarke](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rclarke/32/68604_2.png) [@rclarke](https://discuss.elastic.co/u/rclarke)\
**Post date:** [May 19, 2020, 5:54am UTC](https://discuss.elastic.co/t/table-does-not-show-percentage-when-locale-setting-is-changed/232921/5 "2020-05-19T05:54:12Z")

</div>

This is not fixed in 7.7.x - it will be fixed with the 7.8.0 release:

 ![screenshot-2020-05-19_07-52-03](https://us1.discourse-cdn.com/elastic/original/3X/6/3/63304a9a748cab93d4c1ac64ff521c0f992982ee.png)

I hope you can wait that long - the work around is not to use the Spanish locale.

---

<div class="post-metadata">

**Author:** ![Anabella\_Cristaldi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anabella_cristaldi/32/23612_2.png) [@Anabella\_Cristaldi](https://discuss.elastic.co/u/Anabella_Cristaldi)\
**Post date:** [May 19, 2020, 10:11am UTC](https://discuss.elastic.co/t/table-does-not-show-percentage-when-locale-setting-is-changed/232921/6 "2020-05-19T10:11:23Z")

</div>

Thank you, @rclarke  
We are using elastic/kibana to process data related to COVID-19's tests and we need to present that data with the local formatting to the govern, so it is not a choice for us to not use the Spanish locale ☹ and they need the data ASAP  
I'm trying some Canva's tables in order to represent the same information with the proper format.

Thank you!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [June 16, 2020, 10:11am UTC](https://discuss.elastic.co/t/table-does-not-show-percentage-when-locale-setting-is-changed/232921/7 "2020-06-16T10:11:39Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
