Key purpose
Compare Time to Fill between org units/all by month and for a 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 |
|---|---|
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 |
