Hi all I have data like one one min data like 900000 records so i need to make this data into 1hr

[#1]

HI in this snap shot i have data like one one min like 24hr data so i need to calculate this data into one one 1 hr how to do this 

[Anonymous]

hi,

please elaborate on your requirement

Regards

Neetha

[#3]

Hi Neetha ,

Thanks for Quick Response,

1.i have 900000 Records data ok

2.this is Sep 5th to 11th data ok

3. i have one one min  data comes like 12.00am to 23.00pm means i have minuet wise data so this minuet wise data i want to show hr wise data .ex: 5th of sep i have  12.am to 1am data so i want to calculate this data into 1hr data

i need the script of this

[sunny_talwar]

You can use the group by statement where you will be grouping by each hour. I would recommend creating a column just for hour and use that to do the grouping. And while you are grouping make sure to Sum/Avg/Max/Min a measurement field in the table.

This may or may not make too much sense, but if you can provide some data, it would be easy to show you what I mean.

Best,

S