# Format index pattern field does not work

**URL:** <https://discuss.elastic.co/t/format-index-pattern-field-does-not-work/199503>\
**Category:** Kibana\
**Created:** [September 14, 2019, 1:13pm UTC](https://discuss.elastic.co/t/format-index-pattern-field-does-not-work/199503 "2019-09-14T13:13:26Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![bodo.te](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bodo.te/32/54029_2.png) [@bodo.te](https://discuss.elastic.co/u/bodo.te)\
**Post date:** [September 14, 2019, 1:13pm UTC](https://discuss.elastic.co/t/format-index-pattern-field-does-not-work/199503/1 "2019-09-14T13:13:26Z")

</div>

I have setup metricbeat, logstash, ES and kibana according to the tutorial [https://www.elastic.co/guide/en/elastic-stack-get-started/current/get-started-elastic-stack.html](https://www.elastic.co/guide/en/elastic-stack-get-started/current/get-started-elastic-stack.html)  
which works so far as expected.  
Now I try to understand how to change the format of a field:  
in metricbeats index pattern I changed the format for the field "system.process.memeory.size" to "byte" and the pattern to "0b" .  
However still i see this filed in the "discover" panel as e.g. "1.26GB" instead of the expected "1GB" and in the "visualization" panel i set up a "Top N" with Metrics ="Average" for the same field. Here the memory.size values a displays without any formatting , eg. "4,917,970,944" instead of expected "5GB" .  
What is missing to make this work?

 ![18](https://us1.discourse-cdn.com/elastic/original/3X/c/c/cce3106d472addb0fd5fefacc03de0657a8462e9.png) ![24](https://us1.discourse-cdn.com/elastic/original/3X/d/f/df3ef956792bd94a1f486e9d06a525275044e719.png) ![51](https://us1.discourse-cdn.com/elastic/original/3X/2/5/25b93bbf1d3f585d795099387f61d131bd2b1f4c.png)

---

<div class="post-metadata">

**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\
**Post date:** [September 16, 2019, 2:14pm UTC](https://discuss.elastic.co/t/format-index-pattern-field-does-not-work/199503/2 "2019-09-16T14:14:38Z")

</div>

Hey @bodo.te, which version of Kibana are you using? I'm not seeing the bytes behavior which you report with Discover in Kibana 7.3.

With regard to TSVB, TSVB actually doesn't rely on Kibana's "index patterns", so the formatting which you specify there won't be used by TSVB. [https://github.com/elastic/kibana/issues/15875](https://github.com/elastic/kibana/issues/15875) tracks changing TSVB to use Kibana's "index patterns", so if you'd like to give this issue a +1 or elaborate upon your use-case, it'll help us prioritize this appropriately.

---

<div class="post-metadata">

**Author:** ![bodo.te](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bodo.te/32/54029_2.png) [@bodo.te](https://discuss.elastic.co/u/bodo.te)\
**Post date:** [September 16, 2019, 4:42pm UTC](https://discuss.elastic.co/t/format-index-pattern-field-does-not-work/199503/3 "2019-09-16T16:42:22Z")

</div>

I am using Kibana latest official 7.3. , installed that one just a few days ago on a fresh debian using "deb [https://artifacts.elastic.co/packages/7.x/apt](https://artifacts.elastic.co/packages/7.x/apt) stable main'", just as recommended by [https://www.elastic.co/guide/en/elasticsearch/reference/current/deb.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/deb.html), using a self written ansible playbook, so that i can repeat the installation of all of ELK at any time using the official source.

I actually did expect that the TSVB(=Time Series Visual Builder) is relying on Kibana's Index Pattern. Since it seems not (yet) be the case, how can you change the formatting pattern for the TSVB?

---

<div class="post-metadata">

**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\
**Post date:** [September 16, 2019, 9:12pm UTC](https://discuss.elastic.co/t/format-index-pattern-field-does-not-work/199503/4 "2019-09-16T21:12:23Z")

</div>

Would you mind clicking on the JSON tab in Discover for the document where you're still seeing the `system.process.memory.size` with the decimals, and replying with the contents here?

 ![23%20PM](https://us1.discourse-cdn.com/elastic/original/3X/8/8/88e2f5cbaebaa3dda76d3c59204c6d8b69d44de7.png)

> I actually did expect that the TSVB(=Time Series Visual Builder) is relying on Kibana's Index Pattern. Since it seems not (yet) be the case, how can you change the formatting pattern for the TSVB?

Under Data -\> Options, you can choose a Custom formatter and input your numeral.js formatter:

 ![59%20PM](https://us1.discourse-cdn.com/elastic/original/3X/4/8/48c2b9f87f8dfbf154ad6ad569e577109379b900.png)

---

<div class="post-metadata">

**Author:** ![bodo.te](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bodo.te/32/54029_2.png) [@bodo.te](https://discuss.elastic.co/u/bodo.te)\
**Post date:** [September 19, 2019, 5:03pm UTC](https://discuss.elastic.co/t/format-index-pattern-field-does-not-work/199503/5 "2019-09-19T17:03:59Z")

</div>

Regarding the format in Discover - tab:  
I played with different format settings in management/kibana/index\_patterns : seems sometimes you need to reload the Discover - tab, but sometimes not , to see the change in format.

---

<div class="post-metadata">

**Author:** ![bodo.te](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bodo.te/32/54029_2.png) [@bodo.te](https://discuss.elastic.co/u/bodo.te)\
**Post date:** [September 19, 2019, 5:31pm UTC](https://discuss.elastic.co/t/format-index-pattern-field-does-not-work/199503/6 "2019-09-19T17:31:53Z")

</div>

..and the formating in the Data -\> Options worked, too  
Thanks a lot!  
Bodo

---

<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:** [October 17, 2019, 5:31pm UTC](https://discuss.elastic.co/t/format-index-pattern-field-does-not-work/199503/7 "2019-10-17T17:31:59Z")

</div>

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