# DQL Query Group by Every 2 Hour

**URL:** <https://community.dynatrace.com/t/dql-query-group-by-every-2-hour/42083>\
**Category:** DQL\
**Tags:** dql, notebooks\
**Created:** [October 13, 2023, 4:14pm UTC](https://community.dynatrace.com/t/dql-query-group-by-every-2-hour/42083 "2023-10-13T16:14:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bddang](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/bddang/32/21254_2.png) [@bddang](https://community.dynatrace.com/u/bddang)\
**Post date:** [October 13, 2023, 4:14pm UTC](https://community.dynatrace.com/t/dql-query-group-by-every-2-hour/42083/1 "2023-10-13T16:14:54Z")

</div>

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 }

 ![image (8).png](https://global.discourse-cdn.com/dynatrace/original/3X/a/a/aa2932980fcc8f971a626823fd512e399cd59dc2.png)

---

<div class="post-metadata">

**Author:** ![Tiit\_Hallas](https://avatars.discourse-cdn.com/v4/letter/t/cdc98d/32.png) [@Tiit\_Hallas](https://community.dynatrace.com/u/Tiit_Hallas)\
**Post date:** [October 13, 2023, 5:40pm UTC](https://community.dynatrace.com/t/dql-query-group-by-every-2-hour/42083/2 "2023-10-13T17:40:24Z")

</div>

You can try the **bin** function:&nbsp;[DQL functions — Dynatrace Docs](https://www.dynatrace.com/support/help/shortlink/dql-functions#bin)

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

```
