# How do I translate and format values in report columns

**URL:** <https://discuss.elastic.co/t/how-do-i-translate-and-format-values-in-report-columns/117524>\
**Category:** Elasticsearch\
**Created:** [January 29, 2018, 7:50pm UTC](https://discuss.elastic.co/t/how-do-i-translate-and-format-values-in-report-columns/117524 "2018-01-29T19:50:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![vijayc](https://avatars.discourse-cdn.com/v4/letter/v/ac8455/32.png) [@vijayc](https://discuss.elastic.co/u/vijayc)\
**Post date:** [January 29, 2018, 7:50pm UTC](https://discuss.elastic.co/t/how-do-i-translate-and-format-values-in-report-columns/117524/1 "2018-01-29T19:50:34Z")

</div>

Hi all,

I have created a data table visualization from a search. I want to translate the values in the columns from the raw values to some thing more meaningfull for the user.

**Boolean values**  
Instead of showing true/false, I would like to show Yes/No in the cells.

**Missing values**  
Instead of showing an empty cell where there is no value present, I would like to show "N/A" in the cell.

**Date format**  
For the @timestamp data I want to show the data in mm/dd/yy format, can I provide a date format such as in Java

**Translate values**  
One boolean column has 3 possible values such as 1, 0, -1. I would like show Yes, No, and Uknown instead of the number.

How do you accomplish this in XPack.

Thanks

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [January 29, 2018, 10:10pm UTC](https://discuss.elastic.co/t/how-do-i-translate-and-format-values-in-report-columns/117524/2 "2018-01-29T22:10:27Z")

</div>

Hi,

This might be an expensive operation process wise. But you can use define scripted fields to your fields to show what you want and then display them. You can define them here under index pattern under management:

 ![scripted_field](https://us1.discourse-cdn.com/elastic/original/3X/4/3/434e12dc596b099cf9f555513e30b6a20d53ebd6.jpg)

Here is the documentation for it: [https://www.elastic.co/guide/en/kibana/current/scripted-fields.html](https://www.elastic.co/guide/en/kibana/current/scripted-fields.html)

Painless syntax: [https://www.elastic.co/guide/en/elasticsearch/painless/master/painless-getting-started.html](https://www.elastic.co/guide/en/elasticsearch/painless/master/painless-getting-started.html)

For your third requirement, to change the date format, you can use date formatter on the fields under index pattern in management again:

 ![date_format](https://us1.discourse-cdn.com/elastic/original/3X/f/5/f5167fcb5b189e50012d8196df7e3af449534d71.jpg)

Hope this helps.

Cheers,  
Bhavya

---

<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:** [February 26, 2018, 10:10pm UTC](https://discuss.elastic.co/t/how-do-i-translate-and-format-values-in-report-columns/117524/3 "2018-02-26T22:10:42Z")

</div>

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