# Blank in Kibana Tables

**URL:** <https://discuss.elastic.co/t/blank-in-kibana-tables/381901>\
**Category:** Kibana\
**Tags:** visualisation\
**Created:** [September 12, 2025, 10:58am UTC](https://discuss.elastic.co/t/blank-in-kibana-tables/381901 "2025-09-12T10:58:01Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![elk-user-0001](https://avatars.discourse-cdn.com/v4/letter/e/e47774/32.png) [@elk-user-0001](https://discuss.elastic.co/u/elk-user-0001)\
**Post date:** [September 12, 2025, 10:58am UTC](https://discuss.elastic.co/t/blank-in-kibana-tables/381901/1 "2025-09-12T10:58:01Z")

</div>

Hello, colleagues!

A client has asked me to remove the hyphens (-) from the tables and leave a blank space.

Does anyone know if this is feasible without affecting the fact that it is a numeric field used for averages?

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/6/86b5c928f83e6659ff10c0ce83d4dedc28b428fa.png)

Thank you so much in advanced!

---

<div class="post-metadata">

**Author:** ![carly.richmond](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carly.richmond/32/104935_2.png) [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)\
**Post date:** [September 12, 2025, 1:54pm UTC](https://discuss.elastic.co/t/blank-in-kibana-tables/381901/2 "2025-09-12T13:54:42Z")

</div>

Welcome back @elk-user-0001.

I'm not sure of a way to change it to a blank while keeping it numeric. You could make it 0 using the numeric formatting alongside an `ifelse` similar to the below:

 ![Screenshot 2025-09-12 at 14.50.50](https://us1.discourse-cdn.com/elastic/original/3X/7/c/7ce7612a5cb8314094e5bda17690bc195b51dd2f.png)

The number format uses a similar syntax to numerical.js, [as discussed here](https://www.elastic.co/docs/explore-analyze/numeral-formatting) if you want to try playing with a custom format.

Hope that helps!

---

<div class="post-metadata">

**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\
**Post date:** [September 16, 2025, 9:57am UTC](https://discuss.elastic.co/t/blank-in-kibana-tables/381901/3 "2025-09-16T09:57:06Z")

</div>

`count()`, `unique_count()` and `sum()` should default to 0 when there’s no data (`null`).

For other functions there’s the `default()` which does when @carly.richmond is achieving with `ifelse`.

Unfortunately `defaults()` won’t work where there are no records at all, not sure it’s your case, but there’s an issue you can track about it here: [[Kibana Lens] Possibility to display 0 or any other default value instead '-' in a cell when there's no record to display · Issue #205085 · elastic/kibana · GitHub](https://github.com/elastic/kibana/issues/205085)

---

<div class="post-metadata">

**Author:** ![elk-user-0001](https://avatars.discourse-cdn.com/v4/letter/e/e47774/32.png) [@elk-user-0001](https://discuss.elastic.co/u/elk-user-0001)\
**Post date:** [September 16, 2025, 1:08pm UTC](https://discuss.elastic.co/t/blank-in-kibana-tables/381901/4 "2025-09-16T13:08:18Z")

</div>

Thank you so much @carly.richmond , @Marco_Liberati !!

i was thinking in somthing like an advanced settings or something easy at lens level.

I'll see if the ifelse is sufficient and follow up on the open case you mentioned.

Thank you very much!!!