Icon

004_​Asset_​Utilization (3)

Get exact monthly utilization if every next record for every month is available. Identify average monthly utilization if there are gaps of more than a month in the readings Single table with OrgId, Asset Numberand onc column each for the monthlyutilization over last 18 monthsDon't know how, but I'll get there Node 1Get PreviousReadingAdd RowID-1Add RowIDUtilizationsinceLast RecordCalculate Days ElapsedIdentifyMonthlyAverageBeginningof Month Table Creator Joiner Math Formula Math Formula Math Formula Date&TimeDifference Math Formula Date&Time to String Get exact monthly utilization if every next record for every month is available. Identify average monthly utilization if there are gaps of more than a month in the readings Single table with OrgId, Asset Numberand onc column each for the monthlyutilization over last 18 monthsDon't know how, but I'll get there Node 1Get PreviousReadingAdd RowID-1Add RowIDUtilizationsinceLast RecordCalculate Days ElapsedIdentifyMonthlyAverageBeginningof Month Table Creator Joiner Math Formula Math Formula Math Formula Date&TimeDifference Math Formula Date&Time to String

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: Shai Bedarkar
Created at: 2020-03-29
On NodePit since: 2022-02-06
Last update: 2024-12-18
Created with KNIME version: v4.1.2

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

Try NodePit Runner!