Continuous Meters for Locations or Assets will have an Average Calculation Method specified for calculating the Average Units per day value. Gauge and Characteristic type meters do not have Average calculation method.
Continuous Meters are used to measure consumption or cumulative values. These meters record items like mileage, hours worked, fuel usage or number of items produced. Reading type can be Actual (cumulative) or Delta (incremental). New reading value must be greater than or equal to last reading.
Maximo calculates the daily Average based on the meter readings and average calculation method, There are four types of Average Calculation Methods available: ALL, SLIDING-DAYS,SLIDING-READINGS,STATIC.
ALL
Daily Average is calculated based on all meter readings recorded so far for the meter
Average = (Sum of all delta readings - Delta reading of earliest date) /
( Last reading date – Earliest reading date)
Let us find the Average for ALL calculation type:
Current Date Time - 10-Feb-2024 18:00:00
Average Units per day
= Sum of all delta readings - Delta reading of Earliest Date (31-Jan-2024) /
Last reading date(10-Feb-2024 7:00:07) - Earliest Meter reading date(31-Jan-2024 7:00:07)
= (80+70+50+65+60+70+55+75+65+70+80) - 80 / 10
= 660 / 10 = 66
SLIDING-DAYS
Daily Average is calculated based on last N days of meter readings.
N - SLIDING Window Size
It's used for scenarios where the complete set of odometer readings doesn't make any relevance than taking the last 180/365 days of readings to know the exact overhaul or maintenance requirement.
Average =
(Sum of all delta readings for Sliding days range - Delta reading of earliest date) /
( Last reading Date – Earliest reading date from meter readings Set )
Let us find the Average for 10 Sliding Days:
Current Date Time - 10-Feb-2024 18:00:00
Sliding Date Range starts from = Current Date Time - 10 Days = 31-Jan-202418:00Meter Readings Range starts from values greater than 31-Jan-2024 18:00
Earliest Meter Reading Date = 01-Feb-2021 7:00:07 ( from image list )
Average Units per day
= Sum of all delta readings from 01-Feb-2024 to 10-Feb-2024 - Delta reading of Earliest Date (01-Feb-2024) /
Last reading date (10-Feb-2024 7:00:07) - Earliest Meter reading date (1-Feb-2024 7:00:07)
= (80+70+50+65+60+70+55+75+65+70) - 70 / 9
= 590 / 9 = 65.55
SLIDING-READINGS
Daily Average is calculated based on last N number of meter readings.
N - SLIDING Window Size
Average =
Sum of all delta readings for N sliding readings - Delta reading of earliest date /
( Last reading Date – Earliest reading date from meter readings Set )
Let us find the Average for 5 Sliding readings.
Average Units per day
= Sum of all readings from 06-Feb-2024 to 10-Feb-2024 - Reading of Earliest Date (06-Feb-2024) /
Last reading date (10-Feb-2024 7:00:07) - Earliest Meter reading date (6-Feb-2024 7:00:07)
= (80+70+50+65+60) - 60 / 5
= 265 / 5 = 53
STATIC
User need to manually enter a static value for Average Units/day field
References:
