DQL Bar graph width

[calfano]

Using DQL I have the following query for Davis problems:

fetch events
| filter event.kind == "DAVIS_PROBLEM"
| filter matchesValue(entity_tags, $environment)
| summarize problem_count = count(), by: {`15m interval` = bin(timestamp, 15m)}

which we can display with the following visualization:

Is there a way to make the width of the bar take up the "bin" interval so that I have no gaps between data points?

Thank you!

[Fin_Ubels · Accepted solution]

Hey Calfano,

You can widen the bars by changing the timestamp field to a timeframe field. Currently the bars only represent a sliver of time even though the count is for more than that. In my first example I make them take up the whole minute slot but you can also change it to be half width or whatever width you want by messing with the length of the timeframe as seen in the second and third examples.

Hope this helps!

[calfano]

That works! Thank you so much.