aggregate data to 5min time

[nuwanhwb87]

Hi,

I have below set of data and need to aggregate the data to 5-minute values where the minimum value for every 5th minute is used.

In different time slots current is measured 

Any method. Please help
Thanks.

[vinieme12 · Accepted solution]

create a new field in your data that rounds timestamp to nearest 5th minute

example

timestamp(round(timestamp#('2022-06-01 11:27:30 000000','YYYY-MM-DD h:mm:ss ffffff'),5*60/86400))

will return  '2022-06-01 11:30:00 000000'

create a new field as below

timestamp(round(timestamp#(TIMESTAMPFIELDNAME,'YYYY-MM-DD h:mm:ss ffffff'),5*60/86400)) as roundedTimestamp