# small question about aggregations

**URL:** <https://community.dynatrace.com/t/small-question-about-aggregations/42338>\
**Category:** DQL\
**Tags:** dql\
**Created:** [October 28, 2023, 7:55am UTC](https://community.dynatrace.com/t/small-question-about-aggregations/42338 "2023-10-28T07:55:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![henk\_stobbe](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/henk_stobbe/32/30434_2.png) [@henk\_stobbe](https://community.dynatrace.com/u/henk_stobbe)\
**Post date:** [October 28, 2023, 7:55am UTC](https://community.dynatrace.com/t/small-question-about-aggregations/42338/1 "2023-10-28T07:55:48Z")

</div>

Hello,

Does DQL also do “bucket” aggregations?

Kr Henk

example:

x = 4

y =3

z =8

y = 2

x = 2

query would be, as an example: give me the highest number per letter,

answer

x = 4

y = 3

z = 8

Or a dynatrace example, give me the top cpu load per host.

---

<div class="post-metadata">

**Author:** ![peter\_zahrer](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/peter_zahrer/32/38745_2.png) [@peter\_zahrer](https://community.dynatrace.com/u/peter_zahrer)\
**Post date:** [October 30, 2023, 1:09pm UTC](https://community.dynatrace.com/t/small-question-about-aggregations/42338/2 "2023-10-30T13:09:23Z")

</div>

Hello,

i hope i understood your dataset, but here is a query you could copy paste and see whether it meets your expectations:

```java
data record(letter="X", value=4), record(letter="Y", value=3), record(letter="Z", value=8),
     record(letter="X", value=3), record(letter="Y", value=2), record(letter="Z", value=0)
| summarize max(value), by:letter

```

---

<div class="post-metadata">

**Author:** ![henk\_stobbe](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/henk_stobbe/32/30434_2.png) [@henk\_stobbe](https://community.dynatrace.com/u/henk_stobbe)\
**Post date:** [October 30, 2023, 1:20pm UTC](https://community.dynatrace.com/t/small-question-about-aggregations/42338/3 "2023-10-30T13:20:47Z")

</div>

![henk_stobbe_0-1698671886078.png](https://global.discourse-cdn.com/dynatrace/original/3X/a/9/a9beab17b693b18a37496158f6ceee3a0cf2178f.png)

Hello Peter,

Thanks for your reply, much easier than the competitor (-; I was making it much to difficult, you made my day, thanks!

KR Henk