Events & Downtime

The Events & Downtime dataset lists Events that overlap a period, with event counts, Asset counts and downtime hours inside that period.

At a glance

Item Value
Picker heading Data Tables
One row is One Event in Detail, or one group in Consolidated
Presentations Table, Metric Tile, Bar, Column, Pie, Donut, Treemap, Gauge, Line, Area, Sparklines, Heatmap, Grouped Line, Stacked Bar, Stacked Column, Column Chart Over Time, Line Chart Over Time, Area Chart Over Time
Default presentation Table
Default period Last 30 Days
Date basis Events overlapping period, the only option
Default columns Event Name, Asset Number, Start Date, End Date, Planned Start Date, Event Status, Asset Description
Group Modes Detail and Consolidated, for tables and charts. Charts start on Consolidated.
Drill-through Select a chart value to open its Events

Measures

Measure Unit Aggregation Definition
Event Count Events Count Number of Events that overlap the period.
Asset Count Events Distinct count Number of different Assets with an Event in the period.
Total Event Hours Hours Sum Hours of each Event that fall inside the period, added together.

These measures are also the Consolidated table columns, along with Group.

Columns

These columns are available in Detail tables and View records.

Column Type Description
Event ID Number The Event's internal ID.
Event Name Text The Event's name.
Event Status, Event Type Text The Event's status and type.
Responsibility, Location Text Who is responsible, and where the Event took place.
Task Code, System Code Text The codes on the Event.
Notes Text Event notes.
Start Date, End Date Date When the Event started and ended.
Planned Start Date, Planned End Date Date When the Event was planned to start and end.
Event Duration Hours Number The Event's hours inside the period.
Is Modified Yes/No Whether the Event was modified.
Created Date, Created By, Updated Date, Updated By Mixed Who created and last updated the Event, and when.
Asset Number, Asset Description Text The Event'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
Event Type, Event Status Multiple The Event's type and status.
Responsibility, Location Multiple The Event's responsibility and location.
Past Planned End Yes, No, All Whether the Event has run past its Planned End Date.
Asset Number Multiple The Event'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 Event's Asset Number.
By Month The month of the Event's Start Date.
By Event Type The Event's type.
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.

Series by offers the same list on stacked charts.

Chart notes

  • Compare with is available on the Column Chart and Over Time charts, because the measures need a right-hand axis.
  • Asset Count can be shown only as a Table, Metric Tile, Gauge, Bar or Column Chart.
  • Pie, Donut and Treemap charts are always Consolidated.

Business rules

  • An Event counts if it overlaps the Period. It does not need to start or end inside it.
  • Over Time charts count Events by start date. Event Count uses the period the Event starts in. Total Event Hours are cut to each period.
  • Hours are cut to the Period. An Event that runs past either end adds only the hours inside the Period.
  • Open Events run to now. An Event with no End Date counts its hours up to the current time.
  • Asset Count is not additive. One Asset can appear in two groups, so group values can add up to more than the total.

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