| Tip |
|---|
Key purpose Compare the breakdown of specified diversity responses for selected time periodsby month submitted and against a comparison period. |
Charts
Multi-pie chart for each related diversity metric (or stacked column/bar chart).
By month app submitted for filtered period + total .
Total for comparison period.
Labels are volume/percentage only, colour .
Colour indicates segment name as per chart legend.
The Fancy Stuff
Specific metrics are set up for each separate diversity count, with multiple fields per diversity grouping.
Comparison period data is generated via a union query that matches all other filters and fields but with its own date period and submission period label.
Filters are linked between the master and union query so that restrictions applied to one are also applied to the other, exluding date period filters.
Comparison period filter value (e.g. This Calendar Year) is embedded in the report canvas via parameter replacement text.
Month and comparison period results Results are ordered by hidden columns (year/9999) then by month org ref code (with month names numbered 1-12).
Expansion Ideas
Create version with single pie chart per diversity group, e.g. breakdown for a single job.
Copy and repeat for shortlisted/interviewed/suitable/placed candidates.
| Note |
|---|
Pie and multi-pie charts are only recommended for metrics with up to four segments. Alternative chart types are stacked column or bar charts for metrics with a larger number of segments. |
What You’ll Need
Key |
|---|
Requirement | Example |
|---|---|
Jobs included/excluded | Jobs created this calendar year, vacancy type = External |
Definition of diversity groups | Gender, ATSI, Disability and the individual metrics for each |
Grouping of results in measured period | Month application submitted |
Set or adaptable comparison period | Adaptable (user prompt) filter, default This FInancial Financial Year |
Chart colours | In order of default chart colours |
Additional dashboard breakdowns | Successful candidates only, by job reference, level |
Filters required for report and dashboard filtering | Measured period, comparison period, location, level, job family |