Allow to interpret 0 values in charts as null (and do fitting on them)

[smlbiobot]

This was originally posted to https://discuss.elastic.co/t/how-to-get-stacked-line-chart-to-ignore-no-data-values/94779 — and your team asked me to open an issue here.

Basically, for many of the time series plots, I had to manually select the time intervals because the charts will be rendered as dips to zero when the time is not large enough. This is not the intended behavior.

rashmi (Elastic Team Member) responded by stating that he can reproduce the same behavior, and replied:

I asked our engineer here at elastic and this is what he opines: The reason it dips to zero, is because ES responds with empty buckets . We can’t determine if that is no-data or 0-values, so we drop to 0. This is intended behavior …So the work-around is increasing the time-interval, for more coarser buckets.

So I would like an option to set a field to interpret 0-values as missing data if possible, so that for plots where the intervals are not known before hand, that I can continue to use automatic intervals.

[timroes]

Related to #17717

[stratoula]

This is possible in Lens