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 ?