DQL Query Group by Every 2 Hour

bddang — Fri, 13 Oct 2023 16:14:54 GMT

Hello eveyone!
I'm having the DQL statement prepare for customer. currently, they have summarized by every timestamp of the log. Is there a way to group it by every 2-3 hours?

fetch logs , scanLimitGBytes: -1
|filter isNotNull(elapsed_time)
|summarize elapsed = round(avg(toDouble(elapsed_time)),decimals:3), by:{timestamp }

Re: DQL Query Group by Every 2 Hour

Tiit_Hallas — Fri, 13 Oct 2023 17:40:24 GMT

You can try the bin function: https://www.dynatrace.com/support/help/shortlink/dql-functions#bin

fetch logs , scanLimitGBytes: -1 |filter isNotNull(elapsed_time) |summarize elapsed = round(avg(toDouble(elapsed_time)),decimals:3), by:{ bin(timestamp, 2h) }

topic Re: DQL Query Group by Every 2 Hour in DQL

DQL Query Group by Every 2 Hour

Re: DQL Query Group by Every 2 Hour