Time: by Org Unit/Period/Comparison

Owned by Brendan Codrington
Last updated: Aug 22, 2021
2 min read

Compare average Time to Fill/Recruit/Place per org unit/all for selected time periods.

Key purpose

Compare Time to Fill between org units/all by month and for a comparison period.

Example Time to Fill by Month, Group and Comparison Period

 

Charts

  • Column chart showing average time to fill per month by group and for all groups.

  • Second column chart showing average time to fill for a selected comparison period by group and for all groups.

The Fancy Stuff

  • Time to Fill metric (and the start/end dates it refers to) is set up as a field in your custom view.

  • All Groups, Comparison Period by group and Comparison Period (All Groups) are generated via union queries.

  • Filters are linked between the master and union queries.

  • Comparison period filter value is embedded in the report canvas via parameter replacement text.

  • Month, all group and comparison period results are ordered by a hidden column.

  • All Groups column in comparison period chart is highlighted.

Expansion Ideas

  • Drill through to Average Days at Step report by Group

  • Drill through to Job Details report by Group

What You’ll Need

Key Requirement

Example

Key Requirement

Example

Jobs included/excluded

Vacancy type = External

Definition of time to fill start date, end date and label

Job Open Date, Selection Report step completed, ‘Time to Fill’

Grouping of results in measured period

Month Selection Report step completed

Set or adaptable comparison period

Adaptable (user prompt) filter, default This Financial Year

Chart colours

In order of default chart colours

Filters required for report and dashboard filtering

Measured period, comparison period, location, level, job family

Â