Blank in Kibana Tables

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

2 Likes