Appointments not completed on time

Summary | Guide | Create a Chart | Related Articles


Oneserve Analytics can be used to create many useful reports to provide insight into the day-to-day workings on your mobile workforce. Below is an example of how to generate a report on the percentage of appointments completed on time by each resource.


  • Select Job Appointment as your data source
  • Include the Appointment Planned Start/End Dates and Appointment Actual Start/End Dates in your results

img 1

  • Create a CASE formula to identify if the appointment was completed on time or not:
WHEN [Logi_Appointment.Appointment Planned End Date] < [Logi_Appointment.Appointment Actual End Date]
THEN 100 

img 2

  • Add the formula as a Number data type. You will see a new column added to the report table

img 3

  • To only select appointments which have been completed, you can use the filter Appointment Actual End Date != with a blank date value
  • If you would like to only see jobs that have not been completed on time, you can add another filter for Percentage Completed on Time = 0

img 4

Back to top

Create a Chart

Charts can be generated to visualise the data. In this example, a bar chart has been chosen with the following values:

  • Label Column - Appointment Resource
  • Data Column - Average of Percentage Completed on Time

img 5

Back to top

Related Articles

Back to top

Analytics Overview

Creating Charts and Gauges

Creating Analyses (Selecting Data)

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request