Meter Readings

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.