# Kibana number format display wrong

**URL:** <https://discuss.elastic.co/t/kibana-number-format-display-wrong/173238>\
**Category:** Kibana\
**Created:** [March 21, 2019, 1:38am UTC](https://discuss.elastic.co/t/kibana-number-format-display-wrong/173238 "2019-03-21T01:38:43Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![weizhu](https://avatars.discourse-cdn.com/v4/letter/w/cdc98d/32.png) [@weizhu](https://discuss.elastic.co/u/weizhu)\
**Post date:** [March 21, 2019, 1:38am UTC](https://discuss.elastic.co/t/kibana-number-format-display-wrong/173238/1 "2019-03-21T01:38:44Z")

</div>

I have a json number field. When I choose the display to be "Number", the value displayed are different from what's in the json. If I switch to "String" display, the value is correct. It seems to happen only to the large number. Maybe the number format doesn't handle the large number correctly, or some floating number precision thing. For example

648518552499911557 becomes 648,518,552,499,911,680  
750693969045886946 becomes 750,693,969,045,886,976

We dug in more and found the value displayed in String format is also wrong

We see the value in Number format as  
135389669956256144  
in String format is  
135389669956256130  
If we query ES directly, we got  
135389669956256120

The value stored in ES is correctly, but neither display in Number nor in String is correct

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [March 22, 2019, 12:14pm UTC](https://discuss.elastic.co/t/kibana-number-format-display-wrong/173238/2 "2019-03-22T12:14:52Z")

</div>

This seems to be a limitation of the library used for displaying the numbers (Numeral.js) and somehow in Javascript. [https://github.com/adamwdraper/Numeral-js/issues/308](https://github.com/adamwdraper/Numeral-js/issues/308) You could open a bug report/enhancement request in the Kibana repo, maybe somebody can find a workaround.

---

<div class="post-metadata">

**Author:** ![weizhu](https://avatars.discourse-cdn.com/v4/letter/w/cdc98d/32.png) [@weizhu](https://discuss.elastic.co/u/weizhu)\
**Post date:** [March 22, 2019, 5:19pm UTC](https://discuss.elastic.co/t/kibana-number-format-display-wrong/173238/3 "2019-03-22T17:19:59Z")

</div>

But why the value is still wrong even I choose the display format as String?

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [March 25, 2019, 12:06pm UTC](https://discuss.elastic.co/t/kibana-number-format-display-wrong/173238/4 "2019-03-25T12:06:28Z")

</div>

I think numeral.js is used to read the number first and convert it to string, probably why it's wrong. But I will investigate and see about this.

---

<div class="post-metadata">

**Author:** ![weizhu](https://avatars.discourse-cdn.com/v4/letter/w/cdc98d/32.png) [@weizhu](https://discuss.elastic.co/u/weizhu)\
**Post date:** [March 25, 2019, 5:12pm UTC](https://discuss.elastic.co/t/kibana-number-format-display-wrong/173238/5 "2019-03-25T17:12:16Z")

</div>

I think you are right. Here is the ticket: [https://github.com/elastic/kibana/issues/1274](https://github.com/elastic/kibana/issues/1274)

---

<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:** [April 22, 2019, 5:12pm UTC](https://discuss.elastic.co/t/kibana-number-format-display-wrong/173238/6 "2019-04-22T17:12:17Z")

</div>

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