Question & Answer
Question
Is there a way to calculate average units per day in Maximo?
Answer
Average Units per Day are calculated based on the following Average Calculation Method:
All: Use all readings taken for the given asset and meter to calculate the average.
Date | 10/1/09 | 10/2/09 | 10/3/09 |
Time | 12:00am | 2:00am | 12:00pm |
Reading | 10 (delta) | 10 (delta) | 30 (delta) |
10+10+30 / 2.5 days
Average = 20 units / day
Note: If the above readings were entered after the fact (i.e. 7/1/02) the average would be the same. The date delta is calculated as time between readings, not until today.
Sliding Days: This method uses a sliding window. The user states how many days of readings should be included in the window.
The user has determined that readings from the last 2 days will be used:
Date | 10/2/09 | 10/3/09 | |
Time | 12:00am | 12:00pm | |
Reading | 10 (delta) | 30 (delta) |
20 / 1.5 day
Average = 13.3 units / day
Calculation for Sliding Days:
------------------------------------------------------ Reading Date(new) – Reading Date(new-n) |
Sliding Readings: This method uses a sliding window. The user states how many readings to include in the window, the last ‘n’ readings, and as subsequent readings are taken, the window moves.
The user has determined that only the last 2 readings will be used:
Date | 10/1/09 | 10/2/09 |
Time | 12:00am | 12:00am |
Reading | 10 (delta) | 10 (delta) |
10 / 1 day
Average = 10 units / day
Date | 10/2/09 | 10/3/09 | |
Time | 2:00am | 2:00pm | |
Reading | 10 (delta) | 30 (delta) |
30 / 1.5
Average = 20 units / day
Calculation for Sliding Readings:
------------------------------------------------------ Reading Date(new) – Reading Date(new-n) |
[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Assets","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.1;7.5;7.6","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Was this topic helpful?
Document Information
Modified date:
13 April 2021
UID
swg21406743