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.