How to show zero value in len

[tonyaw]

I had a search result which has non-zero per 2 hours. I want to use Lens to show a sawtooth graph per hour(contains both non-zero value and zero value).
May I ask how to configure it? Currently, I got a straight line result:

My queried data:

Please note that I must use "Top values" instead of "Intervals" for breakdown configuration. Otherwise, I will get another error:

Kibana dashboard filter doesn't work

Thanks for your reminder. Following is the root cause. I used "Intervals" instead of "Top values" wrongly. After change it back to "Top values", Filter works fine. Thanks for your great support! [kibana_issue]

Thanks in advance!

[Marco_Liberati]

Hi @tonyaw

One thing you can do is to configure a Missing value (from the Visual options popover) to use the Zero option, and enforce a 1h date histogram interval.

[tonyaw]

Thanks for your reply.
Actually, I have tried, but nothing is changed:

Shall I must force the time to be 1h?
Could you please help to check if anything is missed?

[Marco_Liberati]

Have you configured a minimum interval in the Date histogram dimension?

[tonyaw]

No change.
BTW. the original value is "Auto(1h)"