May 16, 2023, 3:07am
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:
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!
Thanks in advance!
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.
May 16, 2023, 2:11pm
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?
Have you configured a minimum interval in the
Date histogram dimension?
May 17, 2023, 9:21am
BTW. the original value is "Auto(1h)"