# Aliasing fields in visualizations

**URL:** <https://discuss.elastic.co/t/aliasing-fields-in-visualizations/97650>\
**Category:** Kibana\
**Created:** [August 19, 2017, 6:48am UTC](https://discuss.elastic.co/t/aliasing-fields-in-visualizations/97650 "2017-08-19T06:48:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sLuvpreet33](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sluvpreet33/32/50626_2.png) [@sLuvpreet33](https://discuss.elastic.co/u/sLuvpreet33)\
**Post date:** [August 19, 2017, 6:48am UTC](https://discuss.elastic.co/t/aliasing-fields-in-visualizations/97650/1 "2017-08-19T06:48:44Z")

</div>

I have a Data Table visualization.

 ![image(4)](https://us1.discourse-cdn.com/elastic/original/3X/6/1/619b0acf3defb8428dd9e9aa28402f5bf0bf8fb7.jpg)

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 ?

---

<div class="post-metadata">

**Author:** ![tatdat](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tatdat/32/113160_2.png) [@tatdat](https://discuss.elastic.co/u/tatdat)\
**Post date:** [August 21, 2017, 7:16am UTC](https://discuss.elastic.co/t/aliasing-fields-in-visualizations/97650/2 "2017-08-21T07:16:24Z")

</div>

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](https://www.elastic.co/blog/using-painless-kibana-scripted-fields)**
>
> Kibana provides powerful ways to search and visualize data stored in Elasticsearch. For the purpose of visualizations, Kibana looks for fields defined in Elasticsearch mappings and presents them as op...

---

<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:** [September 18, 2017, 7:16am UTC](https://discuss.elastic.co/t/aliasing-fields-in-visualizations/97650/3 "2017-09-18T07:16:32Z")

</div>

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