how to find cpu usage at max date

[#1]

Hello every one. i am trying to find cpu usage at max date. The dimensions are Host_name, Blade_name. i am expecting to see in bar chart.

  1.05 (last row)

Date	cpu-0
10/3/2014 7:00	1.13
10/3/2014 9:00	1.16
10/3/2014 11:00	1.16
10/3/2014 13:00	1.17
10/3/2014 15:00	1.19
10/3/2014 17:00	1.16
10/3/2014 19:00	1.15
10/3/2014 21:00	1.11
10/3/2014 23:00	1.07
10/4/2014 1:00	1.04
10/4/2014 3:00	1.04
10/4/2014 5:00	1.06
10/4/2014 7:00	1.10
10/4/2014 9:00	1.15
10/4/2014 11:00	1.17
10/4/2014 13:00	1.17
10/4/2014 15:00	1.17
10/4/2014 17:00	1.16
10/4/2014 19:00	1.14
10/4/2014 21:00	1.11
10/4/2014 23:00	1.07
10/5/2014 1:00	1.05
10/5/2014 3:00	1.04
10/5/2014 5:00	1.04
10/5/2014 7:00	1.09
10/5/2014 9:00	1.14
10/5/2014 11:00	1.16
10/5/2014 13:00	1.17
10/5/2014 15:00	1.16
10/5/2014 17:00	1.15
10/5/2014 19:00	1.12
10/5/2014 21:00	1.09
10/5/2014 23:00	1.05

Thanks for your help.

[#2]

Try:

test:

load

FirstSortedValue(cDate,-cDate) as cDate,

FirstSortedValue(cpu,-cDate) as cpu;

LOAD date(date#(cDate, 'MM/DD/YYYY hh:mm'),'MM/DD/YYYY hh:mm') as cDate, cpu INLINE [

    cDate, cpu

    10/5/2014 15:00, 1.16

    10/5/2014 17:00, 1.15

    10/5/2014 19:00, 1.12

    10/5/2014 21:00, 1.09

    10/5/2014 23:00, 1.05

];

Hope this was helpful.

Thanks,

Singh

[sujeetsingh]

Angad have given the best way well you can calculate it by grouping and taking max date in script.

[#4]

Thanks a lot Sujeet, coming this from you really means a lot

[#5]

if i calculate the max date in a script and load the data. How it will work if the user pick a different date from a list box. May be let me rephrase my question, i see there are two things here:

1. by default show cpu utilization for max  date.

2. show cpu usage for a selection day/ week / month by blade.

[anbu1984]

Check this app