Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Here is my data and trying to find max/min total cpu usage . total cpu=Cpu-0+cpu-1+cpu-2+cpu-3
Date | cpu-0 | cpu-1 | cpu-2 | cpu-3 |
10/1/2014 1:00 | 12.20 | 12.30 | 0.00 | 0.00 |
10/1/2014 3:00 | 10.30 | 10.30 | 0.00 | 0.00 |
10/1/2014 5:00 | 16.60 | 16.40 | 0.00 | 0.00 |
10/1/2014 7:00 | 23.30 | 23.30 | 0.00 | 0.00 |
10/1/2014 9:00 | 24.50 | 24.50 | 0.00 | 0.00 |
10/1/2014 11:00 | 26.00 | 25.90 | 0.00 | 0.00 |
10/1/2014 13:00 | 26.90 | 26.40 | 0.00 | 0.00 |
10/1/2014 15:00 | 28.00 | 28.10 | 0.00 | 0.00 |
10/1/2014 17:00 | 27.20 | 27.10 | 0.00 | 0.00 |
10/1/2014 19:00 | 25.60 | 25.50 | 0.00 | 0.00 |
10/1/2014 21:00 | 23.00 | 23.00 | 0.00 | 0.00 |
10/1/2014 23:00 | 16.30 | 16.20 | 0.00 | 0.00 |
10/2/2014 1:00 | 10.80 | 10.80 | 0.00 | 0.00 |
10/2/2014 3:00 | 9.61 | 9.16 | 0.00 | 0.00 |
10/2/2014 5:00 | 16.10 | 15.90 | 0.00 | 0.00 |
10/2/2014 7:00 | 22.80 | 22.80 | 0.00 | 0.00 |
10/2/2014 9:00 | 24.30 | 24.10 | 0.00 | 0.00 |
10/2/2014 11:00 | 25.70 | 25.90 | 0.00 | 0.00 |
10/2/2014 13:00 | 26.20 | 26.40 | 0.00 | 0.00 |
10/2/2014 15:00 | 27.80 | 27.80 | 0.00 | 0.00 |
10/2/2014 17:00 | 27.40 | 27.40 | 0.00 | 0.00 |
10/2/2014 19:00 | 25.70 | 26.00 | 0.00 | 0.00 |
10/2/2014 21:00 | 23.10 | 22.90 | 0.00 | 0.00 |
10/2/2014 23:00 | 17.00 | 16.90 | 0.00 | 0.00 |
10/3/2014 1:00 | 11.00 | 11.20 | 0.00 | 0.00 |
10/3/2014 3:00 | 9.42 | 9.33 | 0.00 | 0.00 |
10/3/2014 5:00 | 15.10 | 14.80 | 0.00 | 0.00 |
10/3/2014 7:00 | 21.80 | 21.60 | 0.00 | 0.00 |
10/3/2014 9:00 | 23.50 | 23.00 | 0.00 | 0.00 |
10/3/2014 11:00 | 24.70 | 24.30 | 0.00 | 0.00 |
10/3/2014 13:00 | 25.30 | 25.10 | 0.00 | 0.00 |
10/3/2014 15:00 | 26.60 | 26.10 | 0.00 | 0.00 |
10/3/2014 17:00 | 25.90 | 25.80 | 0.00 | 0.00 |
10/3/2014 19:00 | 24.60 | 24.30 | 0.00 | 0.00 |
10/3/2014 21:00 | 23.00 | 22.90 | 0.00 | 0.00 |
10/3/2014 23:00 | 17.50 | 17.50 | 0.00 | 0.00 |
in a textbox?
=max(aggr(rangesum([cpu-0],[cpu-1],[cpu-2],[cpu-3]),Date))
in chart ?
=rank(rangesum([cpu-0],[cpu-1],[cpu-2],[cpu-3]))
in a textbox?
=max(aggr(rangesum([cpu-0],[cpu-1],[cpu-2],[cpu-3]),Date))
in chart ?
=rank(rangesum([cpu-0],[cpu-1],[cpu-2],[cpu-3]))