# How can i allow null values in a data table visualization?

**URL:** <https://discuss.elastic.co/t/how-can-i-allow-null-values-in-a-data-table-visualization/137346>\
**Category:** Kibana\
**Created:** [June 26, 2018, 4:06am UTC](https://discuss.elastic.co/t/how-can-i-allow-null-values-in-a-data-table-visualization/137346 "2018-06-26T04:06:31Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dhanashree](https://avatars.discourse-cdn.com/v4/letter/d/8797f3/32.png) [@Dhanashree](https://discuss.elastic.co/u/Dhanashree)\
**Post date:** [June 26, 2018, 4:06am UTC](https://discuss.elastic.co/t/how-can-i-allow-null-values-in-a-data-table-visualization/137346/1 "2018-06-26T04:06:31Z")

</div>

Hi,  
I have created a dashboard which contains a pie chart with two fields as error and success and a data table which is showing the counts of success and error. When i apply filter for error on piechart i am getting the data table as blank as it is getting null value for success column so entire table is displayed as blank How can i resolve this isssue?

---

<div class="post-metadata">

**Author:** ![Stacey\_Gammon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stacey_gammon/32/14025_2.png) [@Stacey\_Gammon](https://discuss.elastic.co/u/Stacey_Gammon)\
**Post date:** [June 26, 2018, 5:13pm UTC](https://discuss.elastic.co/t/how-can-i-allow-null-values-in-a-data-table-visualization/137346/2 "2018-06-26T17:13:30Z")

</div>

Have you tried creating a scripted field based of the field you are using for the columns that returns 0 instead of null?

---

<div class="post-metadata">

**Author:** ![Dhanashree](https://avatars.discourse-cdn.com/v4/letter/d/8797f3/32.png) [@Dhanashree](https://discuss.elastic.co/u/Dhanashree)\
**Post date:** [June 27, 2018, 9:43am UTC](https://discuss.elastic.co/t/how-can-i-allow-null-values-in-a-data-table-visualization/137346/3 "2018-06-27T09:43:27Z")

</div>

Hi @Stacey_Gammon  
Actually by null value i mean it is getting data to be missing for success as i am selecting error in my filter.So my concern is how can i resolve this because adding a field wont help as again the problem will remain same

---

<div class="post-metadata">

**Author:** ![Stacey\_Gammon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stacey_gammon/32/14025_2.png) [@Stacey\_Gammon](https://discuss.elastic.co/u/Stacey_Gammon)\
**Post date:** [June 27, 2018, 1:36pm UTC](https://discuss.elastic.co/t/how-can-i-allow-null-values-in-a-data-table-visualization/137346/4 "2018-06-27T13:36:05Z")

</div>

Can you give me some more information as to what your field mappings for error and success fields look like and perhaps a screenshot of your data table?

---

<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 25, 2018, 1:36pm UTC](https://discuss.elastic.co/t/how-can-i-allow-null-values-in-a-data-table-visualization/137346/5 "2018-07-25T13:36:11Z")

</div>

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