Upload the encrypted file from the HR Data Combiner. Your file stays in this browser.
RegionAll regions
LocationAll locations
DepartmentAll departments
Job titleAll job titles
For best results, select a 12-month period. Untick "Keep to 12 months" to pick any custom date range.
Pulse summary
Headcount
-
Hires
-
Terminations
-
Attrition rate
-Terminations ÷ average headcount
Net movement
-Hires less terminations
Average tenure
-For current employees
Average age
-Current employees with date of birth
Total fortnightly wages
-Current employees · Pay rate × hours × 2
Workforce signals
Charts respond to every slicer and the selected timeline
Workforce movement
Monthly hires, exits and ending headcount
Forecast
Employment status
Filtered records
Headcount by region
As at timeline end
Region
Headcount
Share
Total
0
0%
Terminations by location
Top locations in period
Attrition trend
Monthly rate
Tenure profile
Current employees
Gender representation
Current employees
Count by generation
Based on year of birth
Age group profile
Age at timeline end
Contract type mix
Current employees
Gender pay gap
Average fortnightly wage by gender
Attrition by tenure band
Rate per band, current period
No employee records match the current filters and timeline.
Seasonality
Hires and terminations by calendar month, across years in view
Hires by month
Darker cells mark higher-hiring months
FewerMore
Terminations by month
Darker cells mark higher-exit months
FewerMore
Detailed Workforce Reporting
Opening-to-closing headcount analysis modelled on the supplied workbook. All results respond to the filters and selected timeline.
Headcount
-Current closing headcount
Opening HC
-
Closing HC
-
New hires
-During reporting period
Terminations
-During reporting period
Net change
-Closing HC less opening HC
Turnover rate
-Exits ÷ average headcount
Growth
-Net change ÷ opening HC
Regional Hires vs Terminations
Selected period, by region
Regional Headcount Trend
Last 13 months, by region
Store Headcount Status by Region
Growing, stable, or declining stores
Region
Growing
Stable
Declining
Total
Regional Performance Summary
Region
Opening HC
Closing HC
New Hires
Terminations
Net Change
Turnover Rate
Growth %
Regional Summary
Network and regional headcount by month
Monthly Headcount Movement
Month
Opening HC
New Hires
Terminations
Net Movement
Closing HC
Hire Rate %
Attrition Rate %
Store Location Headcount
Store
Region
Opening HC
Closing HC
New Hires
Terminations
Net Change
Headcount Status
Report Builder
Pick the columns and filters you need, then export a custom report - independent of the filters used elsewhere on this dashboard.
Columns
Filters
RegionAll regions
LocationAll locations
DepartmentAll departments
Job titleAll job titles
GenderAll genders
Contract typeAll contract types
StatusAll statuses
Report preview
Leave Balance
Current annual, sick, and alternate leave balances by employee.
No leave balance data in the uploaded file. Leave Balance is an optional sheet produced by the HR Data Combiner.
RegionAll regions
StoreAll stores
Employment statusAll statuses
Employees with balance
-Matching current filters
Total AL outstanding
-Hours usable now
Total AL accruing
-Hours not yet available
Total sick leave
-Hours balance
Total alternate leave
-Hours balance
High-balance employees
-200+ hours AL outstanding
AL outstanding and accruing
Total hours by type
Balance by leave type
Hours and share of total
Top 10 stores by combined leave balance
All leave types combined, hours
Leave balance by employee
Name
Location
Position
AL Outstanding
AL Accruing
Sick Leave
Alt Leave
Leave Liability
Dollar value of accrued leave by employee.
No leave liability data in the uploaded file. Leave Liability is an optional sheet produced by the HR Data Combiner.
RegionAll regions
StoreAll stores
Employment statusAll statuses
Total liability
-Annual + accrued + alternate
Annual leave outstanding
-Usable now
Annual leave accrued
-Not yet available
Alternate leave
-Dollar value
Average per employee
-Matching current filters
Outstanding and accrued
Annual leave dollar value by type
Liability by type
Dollar value and share of total
Top 10 stores by combined liability
All liability types combined, dollars
Liability by employee
Name
Outstanding $
Accrued $
Alternate $
Total $
Pivot Builder
Drag fields from the list into Filters, Rows, Columns and Values, same as a spreadsheet pivot table. Click any field already in a zone to pick which of its values to include. The result updates live as you build it.
Fields
Dimensions
Measures
Filters
Columns
Rows (up to 2, in order)
Values
Refine which values to include
Add at least one field to Values to build your pivot. Rows, Columns and Filters are all optional.