Diversity: by Period/Comparison

Submitted application diversity volumes compared over selected periods.

Key purpose

Compare the breakdown of specified diversity responses by 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 for comparison period.
Labels are volume/percentage only.
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.
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 columns.

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.

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

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 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