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

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 ?

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.

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