Assets

The Assets dataset lists Assets with their details and latest meter reading, for counting the fleet by type, status, department and more.

At a glance

Item Value
Picker heading Data Tables
One row is One Asset
Presentations Table, Metric Tile, Bar, Column, Pie, Donut, Treemap, Gauge, Line, Area, Heatmap
Default presentation Table
Default period None. This dataset has no Period.
Date basis None. A Heatmap uses Asset Start Date.
Default columns Asset Number, Asset Description, Department, Asset Status, Criticality, Group, Serial Number, Start Date, End Date, Latest Reading Value, Latest Reading Date, plus your meter columns
Group Modes Detail tables. Charts are Consolidated.
Drill-through Column Chart only

Measures

Measure Unit Aggregation Definition
Asset count Assets Count Number of Assets.
Up Assets Assets Count Assets that are not Disposed or Idle / Standby, and have no In Progress Event other than a Standby one.

Columns

Column Type Description
Asset Number, Asset Description Text The Asset.
Asset Code, Serial Number Text The Asset's identifying codes.
Parent Asset Number Text The Asset this one belongs to.
Asset Type, Class, Group, Manufacturer, Category Text The Asset's classification.
Organisation, Department, Cost Centre Text Where the Asset sits in your organisation.
Planning Group, Planning Type Text How the Asset is planned.
Asset Status, Criticality Text The Asset's status and criticality.
Hire Status Yes/No Whether the Asset is on hire.
Disposed Yes/No Whether the Asset is disposed.
Project, Customer Text The Asset's Project and Customer.
Build Year Number The year the Asset was built.
Start Date, End Date Date The Asset's service start and end dates.
Primary Meter, Reading Meter Text The Asset's primary meter, and the meter used for the latest reading.
Latest Reading Value, Latest Reading Date Mixed The latest valid reading on the Reading Meter.
Meter columns Number One column per meter in your tenancy. Some standard meters, such as Odometer and Engine Hours, are not offered.
Created By, Created At, Updated By, Updated At Mixed Who created and last updated the Asset, and when.
Notes Text Asset notes.
Group ID, Group Manufacturer ID, Department ID, Asset Type ID, Planning Type ID, Criticality ID Number Internal IDs, mainly for exports.

Filters

Filter Choice Behaviour
Asset Number Multiple Specific Assets.
Class, Group, Asset Type, Manufacturer Multiple The Asset's classification.
Department Multiple The Asset's department.
Asset Status, Planning Type, Criticality Multiple The Asset's details.
Hire Status Yes, No, All Whether the Asset is on hire.
Disposed Yes, No, All Whether the Asset is disposed. Disposed Assets stay in unless you choose No.
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.
Meter One The meter used for the latest reading.
Days Since Last Meter Reading > Number Assets with no valid reading in this many days.

Group By

Group By Groups by
By Asset Type, By Class, By Group, By Manufacturer The Asset's classification.
By Planning Type, By Plant Status, By Criticality The Asset's details. By Plant Status groups by Asset Status.
By Hire Status On Hire or Off Hire.
By Department The Asset's department.
By Project, By Customer The Asset's Project and Customer.

Chart notes

  • Line and Area charts draw one point per group, because this dataset has no time periods.
  • A Heatmap places each Asset on its Start Date.
  • Series by, Compare and Compare with are not available.

Business rules

  • There is no Period. Use filters to narrow the Assets, such as the End Date filters.
  • Disposed Assets are included by default. Set Disposed to No to count only active Assets.
  • Invalid readings are ignored. Latest Reading Value and Latest Reading Date skip readings marked Invalid.
  • Up Assets counts each Asset once. An Asset with several open Events is still taken off only once.

For shared settings, see Widget and Chart Options. To choose another dataset, see the Data Dictionary.