How do I generate a report of time spent by a fieldworker?
Job Time vs Estimate, in the fieldworker section of the catalogue, answers the question a quote depends on: does the work take as long as we say it will?
It lists a person’s jobs one to a row, with what each was estimated at beside what it actually took. Open it from Add Report — the steps are the same as any other report, and are covered in generating a report.
What it asks for
Section titled “What it asks for”- Date Range — required. Which period of work to look at.
- User(s) — required, and takes more than one, so the report can be a single fieldworker or the whole team over the same range.
- Show Column — which of the columns below to carry.
What comes back
Section titled “What comes back”The heading repeats the range and the people, and then gives the two figures the report exists for: Total Estimated Time and Total Actual Time for everything in it. Those two, side by side, are the answer at the level of a month.
The table underneath is where a difference between them is explained, a job at a time:
| Column | What it tells you |
|---|---|
| Job Code | The job, and the way back to it. |
| Job Status | Whether it is completed, dispatched or still open — see job statuses. |
| Client Name | Who it was for. |
| Scheduled Start and Scheduled Finish | The window the job was planned into. |
| Estimated Time | What the job was expected to take. |
| Actual Start and Actual Finish | When the fieldworker actually started and finished it in the mobile app. |
| Actual Time | What it took. |
| Pause Time | Time the job was paused for, which is why an actual can be shorter than the gap between start and finish. |
| Job Type / Services | What kind of work it was. |
Reading it
Section titled “Reading it”The row worth looking at is the one where estimated and actual are far apart, in either direction.
A job that ran long is the obvious one — it was quoted short, or something on site was not what the job card said. A job that came in well under is worth as much attention, because an estimate that is always generous prices the work wrong and fills the scheduler with time nobody needs.
Jobs that were never started have nothing to compare: they carry an estimate and no actual, and they are dispatched work rather than work that took no time.
Grouped by Job Type / Services, the same report says which kind of work is mis-estimated, which is the version of the answer that changes what you quote — see job type services.
Where else this time appears
Section titled “Where else this time appears”This is the same time that a person’s worklog counts, seen job by job across people instead of day by day for one of them. The Payroll Timesheet on a person’s record puts money against those hours; this report does not.