Asset Performance
The Asset Performance dataset reports availability, utilisation, stoppages, maintenance effort and cost per Asset for one meter. Values are calculated by Samurai in real-time for the selected period.
At a glance
| Item | Value |
|---|---|
| Picker heading | Data Tables |
| One row is | One Asset in Detail, or one group in Consolidated |
| Required setting | One Meter |
| Presentations | All. Heatmap needs a Day measure. Pie, Donut, Treemap and stacked charts need a Sum measure. |
| Default presentation | Table |
| Default period | Last 30 Days. Time charts start on Last Month. |
| Date basis | None. The Period is the reporting window for every measure. |
| Default columns | Asset Number, Asset Description, Department, Utilisation, Latest Reading Value, Asset Status |
| Group Modes | Detail and Consolidated. Charts start on Consolidated. |
| Drill-through | Column Chart and Over Time charts, except with Chart shows Measures |
Measures
The Roll-up column says how a group total is built. Sum adds the Assets together. Recalculated applies the formula to the group's totals, so a percentage is never an average of percentages. Only Sum measures work on Pie, Donut, Treemap and stacked charts.
The Interval column gives the shortest Time interval. Only measures marked Day can use a Heatmap.
In the formulas, Utilisation means the Asset's usage on the selected meter during the period.
| Measure | Unit | Roll-up | Interval | Definition |
|---|---|---|---|---|
| Asset Count | Count | Sum | Day | Number of Assets. |
| Utilisation | Meter unit | Sum | Day | Usage on the selected meter in the period. |
| Calendar Hours | Hours | Sum | Day | Hours in the period for the Asset. |
| Calendar Utilisation | % | Recalculated | Month | Utilisation / Calendar Hours x 100 |
| Mechanical Availability | % | Recalculated | Month | Utilisation / (Utilisation + Stoppage Hours Total) x 100 |
| Calendar Availability | % | Recalculated | Month | (Calendar Hours - Stoppage Hours Total) / Calendar Hours x 100 |
| Availability (%) | % | Recalculated | Month | The same value as Calendar Availability. |
| Downtime (%) | % | Recalculated | Month | Stoppage Hours Total / Calendar Hours x 100 |
| Utilisation of Availability | % | Recalculated | Month | Utilisation / (Calendar Hours - Stoppage Hours Total) x 100 |
| Effective Utilisation | % | Recalculated | Month | Calendar Utilisation x Calendar Availability / 100 |
| Availability Index | % | Recalculated | Month | MTBF / (MTBF + MTTR) x 100 |
| Number of Stoppages | Count | Sum | Day | All stoppages in the period. |
| Planned Stoppages | Count | Sum | Month | Planned stoppages. |
| Breakdown Stoppages | Count | Sum | Month | Breakdown stoppages. |
| Stoppage Hours Total | Hours | Sum | Month | All stoppage hours. |
| Total Downtime Hours | Hours | Sum | Month | The same value as Stoppage Hours Total. |
| Stoppage Hours Planned | Hours | Sum | Month | Planned stoppage hours. |
| Stoppage Hours Breakdown | Hours | Sum | Month | Breakdown stoppage hours. |
| Breakdown Downtime Hours | Hours | Sum | Month | The same value as Stoppage Hours Breakdown. |
| Breakdown Stoppages Percentage | % | Recalculated | Month | Breakdown Stoppages / Number of Stoppages x 100 |
| Planned Stoppages Percentage | % | Recalculated | Month | Planned Stoppages / Number of Stoppages x 100 |
| Planned Downtime Hours Percentage | % | Recalculated | Month | Stoppage Hours Planned / Stoppage Hours Total x 100 |
| Stoppages / 1000 Operating Hours | Ratio | Recalculated | Month | Number of Stoppages / Utilisation x 1000 |
| Downtime per Stoppage | Hours | Recalculated | Month | Stoppage Hours Total / Number of Stoppages |
| MTBS | Meter unit | Recalculated | Month | Mean time between stoppages: Utilisation / Number of Stoppages |
| MTBF | Meter unit | Recalculated | Month | Mean time between failures: Utilisation / Breakdown Stoppages |
| MTBUPS | Meter unit | Recalculated | Month | Mean time between unplanned stoppages: Utilisation / unplanned stoppages |
| MTFS After PM | Meter unit | Recalculated | Month | Mean time to first stoppage after PM: usage to first stoppage / PM count |
| MTTR | Hours | Recalculated | Month | Mean time to repair: Stoppage Hours Breakdown / Breakdown Stoppages |
| Maintenance Ratio | Ratio | Recalculated | Month | Labour hours / Utilisation |
| Maintenance Ratio (Task Work Orders) | Ratio | Recalculated | Month | Task Work Order labour hours / Utilisation |
| Maintenance Ratio (Defects) | Ratio | Recalculated | Month | (Labour hours - Task Work Order labour hours) / Utilisation |
| Work Orders | Count | Sum | Day | Work Orders on the Asset. |
| Task Work Orders | Count | Sum | Day | Work Orders from Tasks. |
| Work Order Duration Hours | Hours | Sum | Day | Duration of the Work Orders. |
| Task Work Order Duration Hours | Hours | Sum | Day | Duration of the Task Work Orders. |
| Task Work Order Percentage | % | Recalculated | Month | Task Work Orders / Work Orders x 100 |
| Defects Created | Count | Sum | Day | Defects created. |
| Defects Completed | Count | Sum | Day | Defects completed. |
| Work Requests Opened | Count | Sum | Day | Created in the period. |
| Work Requests Approved | Count | Sum | Day | Approved in the period. |
| Work Requests Rejected | Count | Sum | Day | Rejected in the period. |
| Open Work Requests | Count | Sum | Day | Still open at the end of the period. |
| Forms Started | Count | Sum | Day | Created in the period. |
| Forms Completed | Count | Sum | Day | Completed and last updated in the period. |
| Forms In Progress | Count | Sum | Day | Still in progress at the end of the period. |
| Forms In Progress Over 30 Days | Count | Sum | Day | In progress at the end of the period and created over 30 days earlier. |
| Labour Cost, Parts Cost, Services Cost | Cost | Sum | Month | Cost by type. |
| Total Cost | Cost | Sum | Month | Total cost for the period. |
| Labour, Parts, Services and Total Cost per Unit | Cost per unit | Recalculated | Month | The cost / Utilisation. The label shows the meter's unit, such as Total Cost per Hour. |
The Work Request and Form counts are available in Consolidated tables, but are not shown until you add them.
Columns
Detail tables can show every measure above except Asset Count, plus these Asset columns.
| Column | Type | Description |
|---|---|---|
| Asset Number, Asset Description | Text | The Asset. |
| Asset Id | Number | The Asset's internal ID. |
| Department | Text | The Asset's department. |
| Asset Class, Asset Group, Asset Type, Manufacturer | Text | The Asset's classification. |
| Planning Type, Criticality, Asset Status | Text | The Asset's details. |
| Is On Hire | Yes/No | Whether the Asset is on hire. |
| Project, Customer | Text | The Asset's Project and Customer. |
| Meter | Text | The selected meter. |
| Latest Reading Value, Latest Reading Date | Mixed | The Asset's latest reading on the selected meter. |
Consolidated tables show Group, Asset Count and the measures.
Filters
| Filter | Choice | Behaviour |
|---|---|---|
| Meter | One, required | The meter used for Utilisation and everything calculated from it. |
| Asset Number | Multiple | Specific Assets. |
| Department | Multiple | The Asset's department. |
| Asset Class, Asset Group, Asset Type, Manufacturer | Multiple | The Asset's classification. |
| Asset Status, Planning Type, Criticality | Multiple | The Asset's details. |
| Is On Hire | On or off | Whether the Asset is on hire. |
| Project, Customer | Multiple | The Asset's Project and Customer. |
| Disposed | Yes, No, All | Disposed Assets are left out unless you choose Yes or All. |
| End Date Preset | One choice | Next 6 months, End of financial year, End of calendar year, Next 12 months or Custom. |
| End Date From, End Date To | Date | The Asset End Date range for a Custom preset. |
| Days Since Last Meter Reading > | Number | Assets whose last reading is older than this many days. |
Group By
| Group By | Groups by |
|---|---|
| By Asset | Each Asset. Charts only. |
| By Asset Type, By Class, By Group, By Manufacturer | The Asset's classification. |
| By Planning Type, By Asset Status, By Criticality | The Asset's details. |
| By Hire Status | On Hire or Off Hire. |
| By Department | The Asset's department. |
| By Project, By Customer | The Asset's Project and Customer. |
Records with no value appear under Unknown. Series by offers the same list on stacked charts.
Chart notes
- Compare offers Planned versus breakdown stoppages, Planned versus breakdown stoppage hours, Calendar versus utilisation hours, and Labour versus parts cost.
- Group Mode set to Detail draws one bar per Asset in the groups. Consolidated draws each group's total.
- Sort By uses each bar's rolled-up value, so there is no choice of how the chart reads a column.
- Stacked charts add up each Asset's value, which is why they need a Sum measure.
Business rules
- Pick the right meter. Every measure based on Utilisation changes with the meter.
- Group ratios are recalculated. A group's Calendar Availability comes from the group's total hours, so it can differ from the average of its Assets.
- A ratio with nothing to divide by shows 0 in tables, but is left out of charts. An Asset with no stoppages has an MTBF of 0 in the table and no bar in the chart.
- Periods with no value are gaps. On a time chart, a period with no value is left blank, not drawn as 0.
- Assets outside the period are dropped. An Asset disposed or end-dated before the period starts does not appear.
- Work Request and Form totals can exceed the group rows. With no filters and no department limits, a Metric Tile counts every request and form, including those with no Asset.
For shared settings, see Widget and Chart Options. To choose another dataset, see the Data Dictionary.