topic Re: DQL Bar graph width in DQL

DQL Bar graph width

calfano — Tue, 01 Aug 2023 13:48:19 GMT

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!

Re: DQL Bar graph width

Fin_Ubels — Tue, 01 Aug 2023 23:15:18 GMT

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!

Re: DQL Bar graph width

calfano — Wed, 02 Aug 2023 01:11:25 GMT

That works! Thank you so much.