# Modifying Data Table field types

**URL:** <https://discuss.elastic.co/t/modifying-data-table-field-types/101682>\
**Category:** Kibana\
**Created:** [September 25, 2017, 10:51am UTC](https://discuss.elastic.co/t/modifying-data-table-field-types/101682 "2017-09-25T10:51:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![cito.ets](https://avatars.discourse-cdn.com/v4/letter/c/4491bb/32.png) [@cito.ets](https://discuss.elastic.co/u/cito.ets)\
**Post date:** [September 25, 2017, 10:51am UTC](https://discuss.elastic.co/t/modifying-data-table-field-types/101682/1 "2017-09-25T10:51:53Z")

</div>

Can anyone point me how to control field types in Data Table metrics and aggregations? (JSON Input?)

e.g. I want percentile values to be displayed as integer and be stripped off of decimal values

---

<div class="post-metadata">

**Author:** ![Joe\_Fleming](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joe_fleming/32/3561_2.png) [@Joe\_Fleming](https://discuss.elastic.co/u/Joe_Fleming)\
**Post date:** [September 25, 2017, 7:41pm UTC](https://discuss.elastic.co/t/modifying-data-table-field-types/101682/2 "2017-09-25T19:41:58Z")

</div>

If you navigate to Management \> Index Patterns, you can pick a formatter for the field, which you can use to round the value when it's displayed in Kibana.

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

---

<div class="post-metadata">

**Author:** ![cito.ets](https://avatars.discourse-cdn.com/v4/letter/c/4491bb/32.png) [@cito.ets](https://discuss.elastic.co/u/cito.ets)\
**Post date:** [September 26, 2017, 7:04am UTC](https://discuss.elastic.co/t/modifying-data-table-field-types/101682/3 "2017-09-26T07:04:57Z")

</div>

Ah. I assumed that only applied to the field and not on the calculations derived from it. This works, thanks.

---

<div class="post-metadata">

**Author:** ![Joe\_Fleming](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joe_fleming/32/3561_2.png) [@Joe\_Fleming](https://discuss.elastic.co/u/Joe_Fleming)\
**Post date:** [September 26, 2017, 3:44pm UTC](https://discuss.elastic.co/t/modifying-data-table-field-types/101682/4 "2017-09-26T15:44:12Z")

</div>

Glad to hear it.

Field formatting should be used anywhere data from that field is displayed in Kibana. Sorry that isn't made more clear. For what it's worth, if you find somewhere that the formatting isn't being observed, that's a bug, and I'd encourage you to open an issue.

---

<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 24, 2017, 3:44pm UTC](https://discuss.elastic.co/t/modifying-data-table-field-types/101682/5 "2017-10-24T15:44:51Z")

</div>

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