Time: by Org Unit/Period
- Brendan Codrington
Compare average Time to Fill/Recruit/Place across quarters and by org unit.
Key purpose
Compare average Time to Recruit for the last four quarters at an organisational level and by org unit.
Â
Charts
Column chart showing average time to fill by quarter.
Trellis chart showing average time to fill per group by quarter.
The Fancy Stuff
Adapted from the EXEC Time to Fill Template.
Time to Fill metric (and the start/end dates it refers to) is set up in custom view.
Time to fill end date field also set up in quarter format in view, presented in Q1 format (Date Heirarchy Format > Prefix Quarter).
Chart colours governed by quarter.
Expansion Ideas
Set up as drill through to separate report with matching results.
Set up as drill down within report through linked organisational levels.
Co-display with additional analysis of days spent at each step per org unit.
What You’ll Need
Key Requirement | Example |
|---|---|
Jobs included/excluded | Vacancy type = External |
Definition of time to recruit start date, end date and label | Job Open Date, Selection Report step completed, ‘Time to Recruit’ |
Grouping of results in measured period | Quarter of time to recruit end |
Filtered period | Previous four quarters |
Chart colours | In order of default chart colours |
Filters required for report and dashboard filtering | Measured period, org unit level, job level, job family |
Â
