Max from statistical chart

[vivekkumark]

I have created a chart with the below query

| chart max(PEAK) as Used max(Available) as "Qty" max(MaxUnused) as "Unused" over NAME by Month

And my result is as below

NAME Qty::Apr Qty::May Qty::Jun Unused::Apr Unused::May Unused::Jun Used::Apr Used::May Used::Jun
Test 10 10 20 1 2 3 9 8 12

I need additional 3 columns based on the above result to show Max Qty (Apr,May,Jun) and Max Used (Apr,May,Jun) and Min Unused (Apr,May,Jun)

Thanks.

[vivekkumark]

Awesome!!

Later found that we can also used if condition

[somesoni2 · Accepted solution]

Try like this (Use some very high number for | eval MinUnused=1000000 if current value is not sufficient)

your search | chart max(PEAK) as Used max(Available) as "Qty" max(MaxUnused) as "Unused" over NAME by Month
| eval MaxQty=0 | eval MaxUsed=0 | eval MinUnused=1000000
| foreach Qty* [eval MaxQty=max('<<FIELD>>',MaxQty)]
| foreach Used* [eval MaxUsed=max('<<FIELD>>',MaxUsed)]
| foreach Unused* [eval MinUnused=min('<<FIELD>>',MinUnused)]