# How to modify data table column values in Kibana

**URL:** <https://discuss.elastic.co/t/how-to-modify-data-table-column-values-in-kibana/248989>\
**Category:** Kibana\
**Created:** [September 17, 2020, 2:00pm UTC](https://discuss.elastic.co/t/how-to-modify-data-table-column-values-in-kibana/248989 "2020-09-17T14:00:44Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![geekganesh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/geekganesh/32/47826_2.png) [@geekganesh](https://discuss.elastic.co/u/geekganesh)\
**Post date:** [September 17, 2020, 2:00pm UTC](https://discuss.elastic.co/t/how-to-modify-data-table-column-values-in-kibana/248989/1 "2020-09-17T14:00:44Z")

</div>

In Elastic search we store events, I have built data table which aggregates based on event types. I have filter which checks for event.keyword : "job-completed". I am getting the count as 1 or 0 but i want to display as completed / in-progress.

How to achieve this in Kibana ?

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [September 17, 2020, 10:15pm UTC](https://discuss.elastic.co/t/how-to-modify-data-table-column-values-in-kibana/248989/2 "2020-09-17T22:15:39Z")

</div>

Welcome to our community! 😃

Ideally you would do this before indexing it to Elasticsearch. How are you sending the data to Elasticsearch?

---

<div class="post-metadata">

**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\
**Post date:** [September 17, 2020, 11:26pm UTC](https://discuss.elastic.co/t/how-to-modify-data-table-column-values-in-kibana/248989/3 "2020-09-17T23:26:13Z")

</div>

You can do this with a static lookup [scripted field](https://www.elastic.co/guide/en/kibana/current/scripted-fields.html) as seen below. But keep in mind that scripted fields are processed for every row, every time it is queried. If performance is not an issue you can do it that way. If performance is an issue then it would be best to create that field before or during ingestion.

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

---

<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 15, 2020, 11:26pm UTC](https://discuss.elastic.co/t/how-to-modify-data-table-column-values-in-kibana/248989/4 "2020-10-15T23:26:13Z")

</div>

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