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