Hi there,
I'm attaching my workbook. For every Half-hour i will get data i need to sort it out to maximum time interval Record and sort the data by 30min (Current time), 1 Hour, Current day,current week and Current month.
please suggest me a proper calculation and sort my issue.
thanks,
suresh
1 件の回答
Hi There,
My question in detail
I want only one record of each service no that should be with the maximum time stamp of that particular day.
And if we use parameter 30min, 1 hour, current Day, current week and Current month then the data should be sorted according to the parameter selection.
Means latest interval timestamp in 30 min and in 1 hour from now last 1 hour data and current day includes whole day data
thankyou,
suresh
