The Meter Readings dataset lists readings recorded on Assets, for checking how often and how well meters are being read.
At a glance
| Item |
Value |
| Picker heading |
Data Tables |
| One row is |
One meter reading |
| Presentations |
Table, Metric Tile, Bar, Column, Pie, Donut, Treemap, Gauge, Line, Area, Sparklines, Heatmap, Grouped Line |
| Default presentation |
Table |
| Default period |
Last 30 Days. Time charts start on Last Month. |
| Date basis |
Reading Date, the only option |
| Default columns |
Value, Meter, Unit, Reading Date, Asset Number, Asset Description, Department, Asset Status |
| Default filter |
Invalid set to No |
| Group Modes |
Detail tables. Charts are Consolidated. |
| Drill-through |
Column Chart only |
Measures
| Measure |
Unit |
Aggregation |
Definition |
| Meter reading count |
Readings |
Count |
Number of meter readings. |
Columns
| Column |
Type |
Description |
| Meter Reading Id |
Number |
The reading's internal ID. |
| Value |
Number |
The reading value. |
| Meter, Unit |
Text |
The meter and its unit. |
| Reading Date |
Date |
When the reading was taken. |
| Invalid |
Yes/No |
Whether the reading is marked Invalid. |
| Created Date, Updated Date |
Date |
When the record was created and last updated. |
| Asset Number, Asset Description |
Text |
The reading's Asset. |
| Department |
Text |
The Asset's department. |
| Class, Group, Asset Type, Manufacturer |
Text |
The Asset's classification. |
| Asset Status, Criticality, Planning Type, Hire Status |
Text |
The Asset's details. |
| Project, Customer |
Text |
The Asset's Project and Customer. |
Filters
| Filter |
Choice |
Behaviour |
| Meter |
Multiple |
The meters to include. |
| Invalid |
No, Yes, All |
Starts on No, which leaves out Invalid readings. |
| Asset Number |
Multiple |
The reading's Asset. |
| Department |
Multiple |
The Asset's department. |
| Class, Group, Asset Type, Manufacturer |
Multiple |
The Asset's classification. |
| Asset Status, Criticality, Planning Type |
Multiple |
The Asset's details. |
| Hire Status |
Yes, No, All |
Whether the Asset is on hire. |
| Project, Customer |
Multiple |
The Asset's Project and Customer. |
Group By
| Group By |
Groups by |
| By Asset |
The reading's Asset. |
| By Department |
The Asset's department. |
| By Class, By Group, By Asset Type, 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 Project, By Customer |
The Asset's Project and Customer. |
Chart notes
- Charts count readings. They do not plot reading values, because meters use different units.
- Series by, Compare and Compare with are not available.
Business rules
- Invalid readings are left out by default. Set Invalid to Yes or All to include them.
- The Period uses Reading Date. It does not use the date the record was created.
For shared settings, see Widget and Chart Options. To choose another dataset, see the Data Dictionary.