how to find max of a series of reccords

Stephen1_Lee — Tue, 30 May 2023 10:16:50 GMT

I can use arrayMax to return a series of records each of which is the max of an array.

But now I want the max of all these records.

max(arrayMax()) and arrayMax(arrayMax()) give an error.

Here is the final part of the DQL.

| fields arrayMax(memory)

It give me these results.

"records": [
{
"arrayMax(memory)": 75.25303777058919
},
{
"arrayMax(memory)": 62.775824546813965
},
{
"arrayMax(memory)": 69.83485221862793
},
{
"arrayMax(memory)": 61.2065970102946
},
{
"arrayMax(memory)": 28.884375000000002
}
],

So how to get the max of these records?

Thank you

Re: how to find max of a series of reccords

Philipp_Kastner — Fri, 12 May 2023 05:00:53 GMT

Hi @Stephen1_Lee

I believe the summarize command should do the trick

| summarize max(`arrayMax(memory)`)

Kind regards,
Philipp

topic how to find max of a series of reccords in DQL

how to find max of a series of reccords

Re: how to find max of a series of reccords