Bar chart won't respect the count of records when interval is by day

[etaoin (David)]

I'm trying to use a bar chart but the count won't match the actual count or even the day when I use the day interval. As you can see the X axis says 2024-06-28 but when hovering it says 27. The count is 164

When I add the time interval by hour, it will now show the correct count. On the selected bar it's 41 and the smaller one is 4. This makes me think there's really not an issue with the data. Any ideas on how to show the correct values when using the interval by day?

[Marco_Liberati]

Hi @etaoin

can you share the time range used to build the first chart?
I see that the second bar starts just before the 28th, so maybe the bucket is starting from the 27th and finishing within the 28th, but the tooltip is referencing only the initial day without notifying about the change of day

[etaoin (David)]

time range was set from 2024-06-27 @ 00:00:00 - 2024-06-30 @ 00:00:00

[Marco_Liberati]

Can you check in the elasticsearch response (Inspect > Response) what are the actual bucket timestamps?