# Heatmap number format

**URL:** <https://discuss.elastic.co/t/heatmap-number-format/91083>\
**Category:** Kibana\
**Created:** [June 28, 2017, 10:37am UTC](https://discuss.elastic.co/t/heatmap-number-format/91083 "2017-06-28T10:37:21Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![\_jake](https://avatars.discourse-cdn.com/v4/letter/_/f08c70/32.png) [@\_jake](https://discuss.elastic.co/u/_jake)\
**Post date:** [June 28, 2017, 10:37am UTC](https://discuss.elastic.co/t/heatmap-number-format/91083/1 "2017-06-28T10:37:22Z")

</div>

How do I specify the number format here. I want to show zero decimal places.

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

Thanks

---

<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:** [June 28, 2017, 11:18am UTC](https://discuss.elastic.co/t/heatmap-number-format/91083/2 "2017-06-28T11:18:14Z")

</div>

You can edit the field formatting for your field.  
This can be done like so:

- go to management -\> Index patterns
- find the field that you're displaying in the heatmap and click on the Edit button on the right (small pencil icon)
- change the format to number and there you can define how many decimal places you want to show  
 ![](https://us1.discourse-cdn.com/elastic/original/3X/f/3/f3e48d4efc2f34d9c92ee476bbd15a1836bcc172.png)

---

<div class="post-metadata">

**Author:** ![\_jake](https://avatars.discourse-cdn.com/v4/letter/_/f08c70/32.png) [@\_jake](https://discuss.elastic.co/u/_jake)\
**Post date:** [June 28, 2017, 12:00pm UTC](https://discuss.elastic.co/t/heatmap-number-format/91083/3 "2017-06-28T12:00:00Z")

</div>

Thanks for your response. Did it actually work for you? It made no difference for me.

---

<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:** [June 28, 2017, 12:01pm UTC](https://discuss.elastic.co/t/heatmap-number-format/91083/4 "2017-06-28T12:01:12Z")

</div>

Did you edit the "Numeral.js format pattern" so that it doesn't show any decimal places?

---

<div class="post-metadata">

**Author:** ![\_jake](https://avatars.discourse-cdn.com/v4/letter/_/f08c70/32.png) [@\_jake](https://discuss.elastic.co/u/_jake)\
**Post date:** [June 28, 2017, 12:09pm UTC](https://discuss.elastic.co/t/heatmap-number-format/91083/5 "2017-06-28T12:09:15Z")

</div>

Yes. I did this..

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

I also observed same problem with scripted and non-scripted fields.

If I use max instead of sum, I can get inconsistent number format like this..

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

---

<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:** [June 28, 2017, 12:19pm UTC](https://discuss.elastic.co/t/heatmap-number-format/91083/6 "2017-06-28T12:19:37Z")

</div>

That looks really weird. I'll investigate this locally.  
Also, fwiw, the missing labels in those cells is due to the size of the number, as it wouldn't fit. But the ones that still show decimal places are really weird.  
What version of Kibana are you using?

---

<div class="post-metadata">

**Author:** ![\_jake](https://avatars.discourse-cdn.com/v4/letter/_/f08c70/32.png) [@\_jake](https://discuss.elastic.co/u/_jake)\
**Post date:** [June 28, 2017, 12:39pm UTC](https://discuss.elastic.co/t/heatmap-number-format/91083/7 "2017-06-28T12:39:43Z")

</div>

Version: 5.2.0  
Thanks very much.

---

<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:** [July 26, 2017, 12:39pm UTC](https://discuss.elastic.co/t/heatmap-number-format/91083/8 "2017-07-26T12:39:43Z")

</div>

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