The Job Analysis - Time to Close dashboard provides insight into how long it takes jobs to be completed from the time they are logged or issued. It enables users to analyse job completion times, compare engineer performance, identify the quickest and slowest completed jobs, and monitor average completion times in days, hours, and minutes.

This dashboard is particularly useful for measuring operational efficiency, monitoring service performance, identifying bottlenecks, and supporting continuous improvement initiatives.

To open the dashboard:

Users can apply any available filters, and all KPI cards, charts, and tables will automatically refresh based on the selected criteria.

The Job Analysis - Time to Close dashboard consists of two pages:

This page provides detailed information about individual job completion times, highlights the quickest and slowest completed jobs, and visualises how long jobs take to close.

A start and end date range calendar picker used to filter jobs by their completed date.

A dropdown filter allowing users to select a Completed Engineer.

A dropdown filter allowing users to select a customer account.

A dropdown filter allowing users to select a site name and location.

A dropdown filter allowing users to select equipment using the Equipment ID and description.

Values

These values represent the elapsed time from the Call Date until the Completed Date.

Category

Displays the three jobs completed in the shortest amount of time. The visual uses conditional ranking to identify the quickest completed jobs based on the combined elapsed days, hours, and minutes.

Values

These values represent the elapsed time from the Call Date until the Completed Date.

Category

Displays the three jobs that took the longest to complete, allowing users to identify unusually long completion times that may require investigation.

This table displays detailed information for each completed job.

Job No. - Displays the unique job number.

Customer - Displays the customer associated with the job.

Account No. - Displays the customer account number.

Site - Displays the site name where the work was carried out.

Call Date - Displays the date and time the job was logged.

From Call Date - Displays the total elapsed time, in minutes, from the job's call date until completion.

From Issue - Displays the total elapsed time, in minutes, from the job's issued date until completion.

Completed - Displays the completed date and time of the job.

Engineer - Displays the engineer who completed the job.

Job Age - Categorises the overall completion time into predefined groups, such as:

These categories help users quickly identify jobs based on how long they took to complete.

Values - Distinct Count of Job Number

Legend - Job Age

Displays the number of completed jobs within each job age category, making it easy to compare completion time distributions.

Values - Distinct Count of Job Number

Legend - Job Age

Shows the percentage distribution of completed jobs across each job age category.

Values

Axis - Completed Engineer

Trellis Columns - Call Date (Month)

Compares the total completion time for each engineer across different months, allowing users to identify performance trends and seasonal workload differences.

This page provides average job completion times grouped into separate tabs for days, hours, and minutes, enabling detailed performance analysis by engineer.

Filters records by completed date.

Filters records using Equipment ID and description.

Filters records by customer.

Filters records by site name and location.

Values - Average Elapsed Time (Days)

Rows - Issued Engineer

Filter - Job State = Completed

Displays the average number of days taken from the issued date until job completion for each engineer.

Values - Average Elapsed Time (Days)

Rows - Issued Engineer

Filter - Job State = Completed

Displays the average number of days taken from the call date until job completion.

Values

Axis - Completed Engineer

Compares the average number of days required by each engineer to complete jobs.

Values - Average Elapsed Time (Hours)

Rows - Issued Engineer

Filter - Job State = Completed

Displays the average number of hours taken from the call date until job completion.

Values - Average Elapsed Time (Hours)

Rows - Issued Engineer

Filter - Job State = Completed

Displays the average number of hours taken from the issued date until completion.

Values

Axis - Completed Engineer

Compares engineers based on their average job completion time measured in hours.

Values - Average Elapsed Time (Minutes)

Rows - Issued Engineer

Filter - Job State = Completed

Displays the average number of minutes between the issued date and job completion.

Values - Average Elapsed Time (Minutes)

Rows - Issued Engineer

Filter - Job State = Completed

Displays the average number of minutes between the call date and job completion.

Values

Axis - Completed Engineer

Provides a detailed comparison of average completion times measured in minutes, making it easier to analyse shorter-duration jobs.

The Job Analysis - Time to Close dashboard is designed to help organisations measure and improve job completion performance. By monitoring the quickest and slowest completed jobs, reviewing average completion times, and comparing engineer performance, users can identify operational trends, improve resource planning, and enhance service efficiency. The combination of detailed job records, KPI summaries, and graphical analysis provides valuable insight into how effectively jobs are completed across the organisation.