small question about aggregations

[henk_stobbe]

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.

[peter_zahrer · Accepted solution]

Hello,

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

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

[henk_stobbe]

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