Aliasing fields in visualizations

[sLuvpreet33 (Luvpreet Singh)]

I have a Data Table visualization.

The statuses have there own values,

1 - Net Banking
2 - Cash On delivery
3 - Mobile payment

Is there any way I can alias these values to their meaning in this data table ?

[tatdat (Dat Pham Tat)]

You can use translate plugin for this data (in logstash).

filter {
  translate {
    dictionary => [ "1", "Net Banking",
                    "2", "Cash On delivery",
                    "3", "Mobile payment" ]
  }
}

Or another way, you can use script field in kibana

 if (doc['payment_status'].value =1) { 
    return "Net Banking";
}
return "";

Using Painless in Kibana scripted fields | Elastic