# How to Handle "null" Values in Visualizations in Kibana 8?

**URL:** <https://discuss.elastic.co/t/how-to-handle-null-values-in-visualizations-in-kibana-8/372006>\
**Category:** Kibana\
**Tags:** visualisation\
**Created:** [December 16, 2024, 6:22am UTC](https://discuss.elastic.co/t/how-to-handle-null-values-in-visualizations-in-kibana-8/372006 "2024-12-16T06:22:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ms.zerone](https://avatars.discourse-cdn.com/v4/letter/m/bc79bd/32.png) [@ms.zerone](https://discuss.elastic.co/u/ms.zerone)\
**Post date:** [December 16, 2024, 6:22am UTC](https://discuss.elastic.co/t/how-to-handle-null-values-in-visualizations-in-kibana-8/372006/1 "2024-12-16T06:22:52Z")

</div>

Hi everyone,

I’m facing an issue in Kibana 8 related to how fields with no data are handled in visualizations (e.g., Enhanced Table).

In Kibana 7, when a field had no data, it would return `0` if the field was set to **number format**. This allowed me to apply CSS conditions like `if value == 0` in computed styles, ensuring the field wouldn’t display anything.

However, in Kibana 8, the same fields seems to return `null` when there’s no data. This behavior is problematic because:

1. I can’t handle `null` values using the same conditions I used before.
2. While `if value <= 0` works, using `if value == 0` or `if value < 0` does not produce the expected result. And I get confused about that!

I want to understand:

1. How does Kibana 8 handle fields with no data differently than Kibana 7?
2. What is the correct approach to control or format these `null` values in visualizations?
3. Is there a way to conditionally handle this without having to rewrite every CSS or computation rule?

Any help or suggestions on how to solve this would be greatly appreciated. Thank you!

---

<div class="post-metadata">

**Author:** ![RainTown](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/raintown/32/140206_2.png) [@RainTown](https://discuss.elastic.co/u/RainTown)\
**Post date:** [December 19, 2024, 7:45pm UTC](https://discuss.elastic.co/t/how-to-handle-null-values-in-visualizations-in-kibana-8/372006/2 "2024-12-19T19:45:04Z")

</div>

Hi

Just to be clear, do you have a generic kibana issue, or do you have a specific issue with the specific Enhanced Table plugin? By which I mean the 3rd party plugin:

> **[GitHub - fbaligand/kibana-enhanced-table: Kibana visualization like a Data Table, but with...](https://github.com/fbaligand/kibana-enhanced-table)**
>
> Kibana visualization like a Data Table, but with enhanced features like computed columns, filter bar, and “Split Cols” bucket

?

Maybe also share some (simple) sample docs that might illustrate the issue

---

<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:** [January 16, 2025, 7:45pm UTC](https://discuss.elastic.co/t/how-to-handle-null-values-in-visualizations-in-kibana-8/372006/3 "2025-01-16T19:45:27Z")

</div>

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