Icon

004_​Asset_​Utilization_​pigreco

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 MonthGet PreviousReading (restored column5)Calculate Days ElapsedNode 30Node 31Node 32IdentifyMonthlyAverageNode 35Node 37Node 38Node 39Node 40Node 41Node 42Node 43Node 44 Table Creator Joiner Math Formula Math Formula Math Formula Date&TimeDifference Math Formula Date&Time to String Joiner Date&TimeDifference String to Date&Time String Manipulation String Manipulation Math Formula Counting Loop Start Double To Int Chunk Loop Start Table Rowto Variable Loop End Loop End Date&Time Shift Date&Time to String Column Filter 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 MonthGet PreviousReading (restored column5)Calculate Days ElapsedNode 30Node 31Node 32IdentifyMonthlyAverageNode 35Node 37Node 38Node 39Node 40Node 41Node 42Node 43Node 44Table Creator Joiner Math Formula Math Formula Math Formula Date&TimeDifference Math Formula Date&Time to String Joiner Date&TimeDifference String to Date&Time String Manipulation String Manipulation Math Formula Counting Loop Start Double To Int Chunk Loop Start Table Rowto Variable Loop End Loop End Date&Time Shift Date&Time to String Column Filter

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-04-19
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!