Overview
The Clock Hours dashboard provides a comprehensive overview of equipment clock hour readings across your fleet. It enables users to monitor equipment usage, identify abnormal reading patterns, analyse historical clock hour trends, compare usage by make and model, and quickly identify equipment that is either under-utilised or heavily used.
To access the dashboard:
Navigate to Self Service from the main navigation menu.
Open the All Standard Dashboards folder.
Locate Clock Hours.
Click Preview to open the dashboard.
Users may apply any of the available dashboard filters. All visualisations automatically refresh based on the selected filter values.
Dashboard Pages
The Clock Hours dashboard consists of five pages:
Clock Hours
Clock Hours - Exceptions
Clock Hour History
By Make Model
Over / Under Usage
Page 1 – Clock Hours
This page provides an overview of the latest equipment clock hour readings, average usage, and reading trends across all equipment.
Dashboard Filters
Filter | Description |
Customer | Filters the dashboard by customer account name and account number. |
Reading Date | Filters records based on the selected clock hour reading date. |
Equipment | Filters the dashboard by equipment ID. |
Equipment User | Filters results by the assigned equipment user. |
Label Slicer – Equipment Status
Column - Equipment Status
Description
Allows users to filter dashboard data by equipment status. Only valid equipment statuses are displayed, as records with NULL equipment status are excluded.
Data Table – Clock Hours
Columns
Equipment
Reading Date
Clock Hours
Previous Reading
Previous Reading Date
Reading Difference
Description
Displays the latest clock hour readings for each equipment, together with the previous recorded reading and the difference between the two readings, allowing users to monitor equipment usage over time.
Pivot Table – Average Clock Hours
Values - Average Clock Hours
Rows
Equipment
Equipment Description
Equipment User
Description
Displays the average recorded clock hours for each equipment, grouped by equipment details and assigned user.
Column Chart – Equipment Clock Hour Reading State
Values - Distinct Count of Equipment
Axis (Category) - Equipment User
Legend (Series) - Clock Hours Increase/Decrease
Description
Shows the number of equipment records for each equipment user, categorised by whether clock hour readings have increased or decreased since the previous reading.
Line Chart – Equipment by Date Reading Taken
Values - Distinct Count of Equipment
Axis (Category) - Reading Date (Year → Month)
Description
Displays the number of equipment readings recorded over time, helping users identify trends in reading activity.
Page 2 – Clock Hours - Exceptions
This page highlights abnormal clock hour readings, particularly equipment whose current clock hour reading is lower than its previous recorded value.
Dashboard Filters
Filter | Description |
Customer | Filters the dashboard by customer account name and account number. |
Reading | Filters records by reading date. |
Equipment | Filters by equipment ID. |
Equipment User | Filters results by the assigned equipment user. |
KPI Chart – Equipment with Decreased Clock Hours
Calculation - Distinct Count of Equipment
Filter - Reading Difference ≤ -1
Description
Displays the number of equipment records where the current clock hour reading is lower than the previous reading, helping identify potential data entry errors or abnormal readings.
Label Slicer – Equipment Status
Column - Equipment Status
Description
Allows users to filter dashboard data by equipment status.
Line Chart – Decreased Clock Hours – Readings
Values - Distinct Count of Equipment
Axis (Category) - Reading Date (Year → Month)
Filter - Reading Difference < 0
Description
Shows when decreased clock hour readings occurred over time.
Pie Chart – Equipment User Decreased
Values - Distinct Count of Equipment
Legend - Equipment User
Filters
Reading Difference < 0
Equipment User is not NULL
Description
Displays the distribution of decreased clock hour readings by equipment user.
Line Chart – Decreased Equipment Usage
Values - Distinct Count of Equipment
Axis - Reading Date (Year → Month)
Filter - Reading Difference < 0
Description
Illustrates trends of equipment with decreased usage readings across the selected time period.
Data Table
Columns
Equipment
Current Reading Date
Clock Hours
Previous Reading Date
Previous Reading
Days Between Readings
Current Clock Hours Reading
Equipment User
Reading Difference
Description
Provides detailed information for all equipment with recorded clock hour readings, making it easier to investigate decreases and identify possible inconsistencies.
Page 3 – Clock Hour History
This page focuses on historical clock hour readings and identifies equipment with irregular reading intervals.
Dashboard Filters
Filter | Description |
Customer | Filters by customer account name and account number. |
Equipment | Filters by equipment ID. |
Make | Filters equipment by manufacturer. |
Model | Filters equipment by model. |
Label Slicer – Equipment Status
Column - Equipment Status
Description
Allows users to filter records by equipment status.
Combined Chart – Clock Hours Readings vs Average
Left Value Axis
Sum of Clock Hours
Average of Clock Hours
Axis - Equipment
Description
Compares total clock hour readings against the average reading for each equipment, making it easier to identify unusually high or low usage.
Column Chart – Equipment Reading Gaps
Values - Distinct Count of Equipment
Legend - Gap Between Reading (Days)
Filter - Days Between Readings is not NULL or 0
Description
Displays equipment grouped by the number of days between recorded readings, helping identify long periods without updates.
Column Chart – Count of Equipment with Largest Reading Gaps
Values - Distinct Count of Equipment
Legend - Gap Between Reading (Days)
Filters - Days Between Readings is not NULL or 0
Conditional Visualisation - Top 10 ranked by reading gap
Description
Highlights the ten equipment records with the largest gaps between clock hour readings, allowing users to identify assets requiring closer monitoring.
Page 4 – By Make Model
This page analyses clock hour readings by equipment manufacturer and model.
Dashboard Filters
Filter | Description |
Customer | Filters by customer account name and account number. |
Equipment | Filters by equipment ID. |
Make | Filters by equipment manufacturer. |
Model | Filters by equipment model. |
Label Slicer – Equipment Status
Column - Equipment Status
Description
Filters the dashboard by equipment status.
Line Chart – Clock Hours Readings
Values - Distinct Count of Equipment
Axis - Equipment Make
Description
Displays the number of equipment readings grouped by equipment manufacturer.
Column Chart – Clock Hours Readings
Values - Distinct Count of Equipment
Axis - Equipment Make
Description
Provides an alternative comparison of clock hour readings across equipment manufacturers.
Combined Chart – Clock Hours Readings vs Average
Left Value Axis
Sum of Clock Hours
Average of Clock Hours
Axis - Equipment
Trellis Columns
Equipment Make
Equipment Model
Conditional Visualisation - Top 10 ranked by Sum of Clock Hours
Description
Compares total and average clock hour readings for the top ten equipment grouped by manufacturer and model.
Column Chart – Clock Hours Reading
Values - Distinct Count of Equipment
Axis - Clock Hours
Legend - Equipment Model
Trellis Rows - Reading Date (Year → Month)
Description
Displays clock hour readings by equipment model over time, making it easier to compare usage patterns across different equipment models.
Page 5 – Over / Under Usage
This page identifies equipment with the highest and lowest clock hour usage.
Dashboard Filters
Filter | Description |
Customer | Filters the dashboard by customer account name and account number. |
KPI Kanban – Under Used – Lowest Clock Hours
Values
Clock Hours (Maximum)
Rank
Category - Equipment
Sorting - Clock Hours Ascending
Conditional Visualisation - Bottom 10 ranked by Sum of Clock Hours
Description
Displays the ten least utilised equipment based on recorded clock hours.
KPI Kanban – High Usage – Top 10 with Highest Clock Hours
Values
Clock Hours (Maximum)
Rank
Category - Equipment
Sorting - Clock Hours Descending
Conditional Visualisation - Top 10 ranked by Sum of Clock Hours
Description
Displays the ten highest utilised equipment based on recorded clock hours.
Pivot Table – Under Used – Lowest Clock Hours
Values
Minimum Reading
Maximum Reading
Rank
Rows - Equipment ID
Sorting - Maximum Reading Ascending
Conditional Visualisation - Bottom 10 ranked by Sum of Clock Hours
Description
Provides detailed information for equipment with the lowest recorded clock hour usage.
Pivot Table – High Usage – Top 10 with Highest Clock Hours
Values
Minimum Reading
Maximum Reading
Rank
Rows - Equipment ID
Sorting - Maximum Reading Descending
Conditional Visualisation - Top 10 ranked by Sum of Clock Hours
Description
Displays detailed information for equipment with the highest recorded clock hour usage.
Final Remarks
The Clock Hours dashboard provides valuable insight into equipment utilisation by tracking clock hour readings, identifying unusual changes, monitoring historical trends, and highlighting both under-utilised and heavily used assets. It enables users to validate clock hour data, detect potential recording anomalies, monitor equipment performance over time, and support maintenance planning and operational decision-making through comprehensive clock hour analysis.