# Data Defining

**URL:** <https://discuss.elastic.co/t/data-defining/24005>\
**Category:** Kibana\
**Created:** [June 19, 2015, 4:31pm UTC](https://discuss.elastic.co/t/data-defining/24005 "2015-06-19T16:31:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lucky](https://avatars.discourse-cdn.com/v4/letter/l/e9c0ed/32.png) [@Lucky](https://discuss.elastic.co/u/Lucky)\
**Post date:** [June 19, 2015, 4:31pm UTC](https://discuss.elastic.co/t/data-defining/24005/1 "2015-06-19T16:31:56Z")

</div>

I am new to Kibana. I am able to create visualizations but the challenge i am facing is, In the data sets some of the fields values are numeric but in actual the numeric values defines a term, for example in Gender field it has values 0,1 & 2 where 0 means unknown, 1 means male and 2 means female.  
So in Kibana if i select the gender field it is displaying the numeric values which i do not what to, I want to display the actual values of the gender.

So can you please help me in a way to create scripted fields or is there any other way to display the values.

Thank you very much.

---

<div class="post-metadata">

**Author:** ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)\
**Post date:** [June 19, 2015, 5:41pm UTC](https://discuss.elastic.co/t/data-defining/24005/2 "2015-06-19T17:41:08Z")

</div>

Right now there isn't a way to define a mapping from a numerical field with a fixed number of values to strings corresponding to those values in Kibana.

The best thing I can think of is to do the mapping as you're indexing the data (presumably in Logstash?) by using something like a "translate" filter: [https://www.elastic.co/guide/en/logstash/current/plugins-filters-translate.html](https://www.elastic.co/guide/en/logstash/current/plugins-filters-translate.html)

For a small number of fairly static values this should work well.

---

<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:** [July 6, 2017, 2:17pm UTC](https://discuss.elastic.co/t/data-defining/24005/3 "2017-07-06T14:17:46Z")

</div>


