topic small question about aggregations in DQL

small question about aggregations

henk_stobbe — Sat, 28 Oct 2023 08:02:36 GMT

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.

Re: small question about aggregations

peter_zahrer — Mon, 30 Oct 2023 13:09:23 GMT

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

Re: small question about aggregations

henk_stobbe — Mon, 30 Oct 2023 13:21:33 GMT

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