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.