How to handle gaps in date histogram (missing values) in Kibana and Elastic Search?

Your workaround of setting the time interval is the same as what I would recommend. The only alternative is to use a Lens line chart in 7.9 or higher, where we support fitting functions: https://github.com/elastic/kibana/pull/69820

We are planning on adding more support for fitting on area charts in a future version.

1 Like