1. Home
  2. Reporting
  3. Working with Reports
  4. Times Report Example Scenarios

Times Report Example Scenarios

From your

Applies to ,

Overview

This article provides examples of some data that can be pulled from the Times report within the reporting feature of When I Work.

Reporting experience

The reporting experience within When I Work encompasses a few different types of reports and exports. Use the following links to explore each in more detail:

Custom Report Data Availability

The data available in the custom report is current as of the prior midnight in your account’s timezone. Any data from midnight until the current time will be reflected in the next day’s report.

Example scenarios

View an employee’s clocked times

If you’re having performance issues with a particular employee, you might want to review all their punched times to check for irregularities. 

  1. Hover over Workplace, then select Reports.

  2. Create a Times report for the date range you want.
  3. Filter by:
    • Employee Last Name
    • Employee First Name
    • Employee ID

Summarize worked hours by schedule and position

You might want to summarize worked hours to compare them with the plan as recorded in the schedule.

  1. Hover over Workplace, then select Reports.

  2. Create a Times report for the date range you want.
  3. Click Columns, then click Pivot Mode.
  4. Drag Schedule Name to Row Groups.
  5. Drag Length to Values, then click to select sum function.
  6. Drag Position Name to Column Labels.

Find all times that clocked in early

If you suspect employees are clocking in early, you can run this report to find all punches to see if there’s a pattern of behavior that needs to be corrected.

  1. Hover over Workplace, then select Reports.

  2. Create a Times report for the date range you want.
  3. Expand Clock In Was Early filter, then select true.

Find early and late punches by employee

  1. Hover over Workplace, then select Reports.

  2. Create a Times report for the date range you want.
  3. Filter one of the following columns to true values:
    • Clock In Was Early
    • Clock Out Was Early
    • Clock In Was Late
    • Clock Out Was Late
  4. Group by Employee Name.

Find all times that were late clock outs

This report is useful when you want to see all employees that were late clocking out across all schedules.

  1. Hover over Workplace, then select Reports.

  2. Create a Times report for the date range you want.
  3. Click the Clock Out Was Late filter, then select true.

clock out was late

Find times for an archived employee

If you want to view an archived employee’s time entries, simply run a report filtered by the employee’s name.

  1. Hover over Workplace, then select Reports.

  2. Create a Times report for the date range you want.
  3. Expand Employee Name filter and select the archived employee’s name.

Find all clock in methods

This report is useful to see what methods your employees are using to clock in (mobile, terminal, computer).

  1. Hover over Workplace, then select Reports.

  2. Create a Times report for the date range you want.
  3. Click Columns, then drag Clock In Method (or Clock Out Method) to Row Groups.
  4. Optional: Drag Employee Name to Row Groups, then click Pivot Mode to group the clock-in methods by employee.

Find all clock in or clock out locations

This report is useful to see if employees are clocking in from locations you expect.
Note: If using Latitude and Longitude for location you may need to use third-party software to determine the exact location.

  1. Hover over Workplace, then select Reports.

  2. Create a Times report for the date range you want.
  3. Filter the report by the person or group you are interested in (employee, schedule, job site).
  4. Look at the following columns in the report or pin them for easier visibility:
    • For clock in behaviors, choose Clock In IP Address, Clock In Latitude, and Clock In Longitude.
    • For clock out behaviors, choose Clock Out IP Address, Clock Out Latitude, and Clock Out Longitude.

View employees’ clocked times by schedule or job site

This report is useful when you need to review employee punches by schedule or job site in one place. There are two methods you can use:

Filter method

  1. Hover over Workplace, then select Reports.

  2. Create a Times report for the date range you want.
  3. Click Columns, then drag Employee Name to Row Groups.
  4. Click Filters, then filter by:
      • Schedule Name
      • Job Site Name

Group method

  1. Hover over Workplace, then select Reports.

  2. Create a Times report for the date range you want.
  3. Click Columns, then drag Employee Name, Schedule Name and Job Site Name to Row Groups.

Summarize worked hours by (employee / position / schedule)

This report is useful when you want to see worked costs broken down in various ways to see where worked hours are coming from.

Employee-centric approach

  1. Hover over Workplace, then select Reports.

  2. Create a Times report for the date range you want.
  3. Click Columns, then click Pivot Mode.
  4. Drag Employee Name to Row Groups.
  5. Drag Length to Values. Click Length to select sum.

Schedule/position-centric approach

  1. Hover over Workplace, then select Reports.

  2. Create a Times report for the date range you want.
  3. Click Columns, then click Pivot Mode.
  4. Drag Schedule Name and Position Name to Row Groups.
  5. Drag Length to Values. Click Length to select sum.

Updated on May 18, 2022

Was this article helpful?

Related Articles

Still Need Help?

Open a ticket with our customer care team.

Submit a Ticket