Icon

20221229 Pikairos calculate average value per hour for non uniformly sampled time data series

This workflows brings an answer to the question asked at post # 57613:

I have a time data series that is not uniform (values are taken at arbitrary intervals).
I want to calculate the average value per hour. How can I do that? A Group By node will calculate the mean value of all the measures in a given hour but it is different from what I need.

Time SeriesDataSplit at"+01:00"Lag by 1Date-TimeCompute DifferenceBetweenDate & Lagged DateHandleMissing Valueat BeginingExtract Year,Month, Day & HourGroup byYear-Moth-Day-Hour& AggregateTotal Running Time& Machine Running TimeMultiply# of Machineby the Timeit was Working% TimeMachine RunningAbsolute TimeMachine Runningin Minutesper Hour IntervalExcel Reader String to Date&Time Cell SplitterBy Position Lag Column Date&TimeDifference Rule Engine Extract Date&TimeFields GroupBy Math Formula Math Formula Math Formula Time SeriesDataSplit at"+01:00"Lag by 1Date-TimeCompute DifferenceBetweenDate & Lagged DateHandleMissing Valueat BeginingExtract Year,Month, Day & HourGroup byYear-Moth-Day-Hour& AggregateTotal Running Time& Machine Running TimeMultiply# of Machineby the Timeit was Working% TimeMachine Running Absolute TimeMachine Runningin Minutesper Hour IntervalExcel Reader String to Date&Time Cell SplitterBy Position Lag Column Date&TimeDifference Rule Engine Extract Date&TimeFields GroupBy Math Formula Math Formula Math Formula

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Molina
Created at: 2022-12-29
On NodePit since: 2022-12-29
Last update: 2026-01-07
Created with KNIME version: v4.5.2
Tags: Time SeriesNon uniform Time Series

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!