DQL Query Group by Every 2 Hour

[bddang]

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 }

[Tiit_Hallas · Accepted solution]

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) }