# After transforming multiple indexes I need to display the status as text value

**URL:** <https://discuss.elastic.co/t/after-transforming-multiple-indexes-i-need-to-display-the-status-as-text-value/270772>\
**Category:** Kibana\
**Created:** [April 20, 2021, 10:44pm UTC](https://discuss.elastic.co/t/after-transforming-multiple-indexes-i-need-to-display-the-status-as-text-value/270772 "2021-04-20T22:44:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ajaay\_kannan\_Vr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ajaay_kannan_vr/32/87205_2.png) [@ajaay\_kannan\_Vr](https://discuss.elastic.co/u/ajaay_kannan_Vr)\
**Post date:** [April 20, 2021, 10:44pm UTC](https://discuss.elastic.co/t/after-transforming-multiple-indexes-i-need-to-display-the-status-as-text-value/270772/1 "2021-04-20T22:44:49Z")

</div>

There are 3 different indexes which will collect data from different system. To consolidate to one view pivot option used and to display the latest status instead of text I created as Number format so while doing pivot transform I can use the max(status) to display the latest status. Now I would like to display some fixed status text instead of number while displaying in kibana.  
Ex: if 0 - Initiated, 1-Inprogress, 2- Completed

Is there any option available to do as per the above requirement ?

---

<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:** [April 22, 2021, 1:47pm UTC](https://discuss.elastic.co/t/after-transforming-multiple-indexes-i-need-to-display-the-status-as-text-value/270772/2 "2021-04-22T13:47:40Z")

</div>

You can go to the fields formatter in the index pattern details and set that number field to be of "Static lookup" format. Then you can map each number to whatever text you like.

---

<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:** [May 20, 2021, 1:47pm UTC](https://discuss.elastic.co/t/after-transforming-multiple-indexes-i-need-to-display-the-status-as-text-value/270772/3 "2021-05-20T13:47:59Z")

</div>

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