Jobs: Current Step Alerts
- Brendan Codrington
Volume of jobs assigned to specified user with days at step alerts.
Key purpose
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 |
|---|---|
Jobs 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 |
Filters required for report filtering | Job type, job status, user, current step name |
