- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
aggregate data to 5min time
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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If a post helps to resolve your issue, please accept it as a Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If a post helps to resolve your issue, please accept it as a Solution.