# Visualize empty values in data table visualization **URL:** \ **Category:** Kibana\ **Created:** [February 25, 2019, 7:24pm UTC](https://discuss.elastic.co/t/visualize-empty-values-in-data-table-visualization/169896 "2019-02-25T19:24:02Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![LucasD](https://avatars.discourse-cdn.com/v4/letter/l/6f9a4e/32.png) [@LucasD](https://discuss.elastic.co/u/LucasD)\ **Post date:** [February 25, 2019, 7:24pm UTC](https://discuss.elastic.co/t/visualize-empty-values-in-data-table-visualization/169896/1 "2019-02-25T19:24:03Z")
I'm beginning with ELK and we're trying to create a table visualization that should display an "Expected Date" for a specific event. However, it is really common to have empty values for this field, and it would be extremely important for us to identify on the table visualization which rows lack the forecast for this event I've mentioned before. Is there anyway I can set this visualization to show data like the following example? ID | ExpectedDate | event1 | 21/12/2020| event2 | | event3 | 22/12/2020| ... Indexing empty values doesn't work for us because they don't show up on table visualization. ---
**Author:** ![thomasneirynck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thomasneirynck/32/23313_2.png) [@thomasneirynck](https://discuss.elastic.co/u/thomasneirynck)\ **Post date:** [February 27, 2019, 4:09pm UTC](https://discuss.elastic.co/t/visualize-empty-values-in-data-table-visualization/169896/2 "2019-02-27T16:09:26Z")
@LucasD I expect you could create a scripted field that maps the date-field to a string-field, showing an empty string for when the date-field is missing cf. [https://www.elastic.co/guide/en/kibana/current/scripted-fields.html](https://www.elastic.co/guide/en/kibana/current/scripted-fields.html) Iso of showing the date-field in your data-table, show that new scripted-field. ---
**Author:** ![LucasD](https://avatars.discourse-cdn.com/v4/letter/l/6f9a4e/32.png) [@LucasD](https://discuss.elastic.co/u/LucasD)\ **Post date:** [February 27, 2019, 6:29pm UTC](https://discuss.elastic.co/t/visualize-empty-values-in-data-table-visualization/169896/3 "2019-02-27T18:29:35Z")
Could you please help me with the syntax? I'm not used to painless expressions ---
**Author:** ![thomasneirynck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thomasneirynck/32/23313_2.png) [@thomasneirynck](https://discuss.elastic.co/u/thomasneirynck)\ **Post date:** [February 27, 2019, 7:52pm UTC](https://discuss.elastic.co/t/visualize-empty-values-in-data-table-visualization/169896/4 "2019-02-27T19:52:31Z")
hi @LucasD, I'd start here: [https://www.elastic.co/blog/using-painless-kibana-scripted-fields](https://www.elastic.co/blog/using-painless-kibana-scripted-fields) For more detailed info, this is a good entry-point as well: [https://www.elastic.co/guide/en/elasticsearch/painless/current/painless-examples.html](https://www.elastic.co/guide/en/elasticsearch/painless/current/painless-examples.html) ---
**Author:** ![LucasD](https://avatars.discourse-cdn.com/v4/letter/l/6f9a4e/32.png) [@LucasD](https://discuss.elastic.co/u/LucasD)\ **Post date:** [February 28, 2019, 4:27pm UTC](https://discuss.elastic.co/t/visualize-empty-values-in-data-table-visualization/169896/5 "2019-02-28T16:27:40Z")
Thanks for you help, @thomasneirynck ! I really appreciate it (: I've created a scripted field and it worked great. However, I ended up adding an extra field to my CSV that contains the exactly same values but mapped as text. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [March 28, 2019, 4:27pm UTC](https://discuss.elastic.co/t/visualize-empty-values-in-data-table-visualization/169896/6 "2019-03-28T16:27:41Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.