| Tip |
|---|
Key purpose Compare the breakdown of jobs for a specified job field, by month opened and compared to another time period. |
| Excerpt |
Charts
Multi-pie chart (or stacked column/bar chart).
By month job open for filtered period.
Total for comparison period.
Labels are volume/percentage only
Colour indicates segment name as per chart legend.
The Fancy Stuff
Table includes count of jobs and calculated percentage of column total.
Comparison period data is generated via a union query
Filters are linked between the master and union query
Comparison period filter value (e.g. This Calendar Year) is embedded in the report canvas via parameter replacement text.
Results are ordered by hidden numbered columns.
Expansion Ideas
Copy and repeat with another custom GQ
Section results by another custom GQ to compare one with another
See number of jobs by how many are above step warnings and limits, ordered by those assigned to a specific user (e.g. creator/recruiter/recruitment officer). |
Charts
Column chart for jobs over days at current step warning.
Column chart for jobs over days at current step limit.
The Fancy Stuff
Calculated fields assigning warning and limit benchmarks for specific processes and step names, and if job is above warning or limit.
Conditional formatting of Days at Step column.
Results sorted by assigned user.
Subtotal of total jobs by assigned user.
Expansion Ideas
Use as drill through from report summarising number of jobs against an assigned user.
Section results assigned user.
Apply access filters for assigned users to only see their jobs.
What You’ll Need
Key Requirement | Example | ||
|---|---|---|---|
Specification of job field for job count breakdown | Job level | ||
Grouping of results in measured period | Month job opened | ||
Set or adaptable comparison period | Adaptable (user prompt) filter, default This Financial YearJobs included/excluded | Jobs not archived, vacancy type = External | |
Step warnings and limits by step name | “Shortlisting” warning is 7 days, limit is 10. | ||
Assigned user | Job Creator field | ||
Chart colours | In order of default chart colours | Additional dashboard breakdowns | Jobs by other job fields, specific job types |
Filters required for report and dashboard filtering | Measured period, comparison period, location, level, job familyJob type, job status, user, current step name |