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.