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?
Thank you so much in advanced!
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:
The number format uses a similar syntax to numerical.js, as discussed here if you want to try playing with a custom format.
Hope that helps!
2 Likes
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
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!!!
1 Like