Advanced Analytics - Absences dashboard

Introduction

The Absences Dashboard provides a complete overview of employee absence patterns across your organization. It allows you to track total absence hours, understand absence types and reasons, explore trends over time, and drill down into detailed information at unit, section, or employee level.

This dashboard is designed for managers, HR partners, and operational leaders who need clear visibility into absenteeism to support workforce planning, staffing decisions, and policy improvement.

How it works

The Absences Dashboard contains three core analytical views:

1. Overview – High-level metrics and absence trends

2. Hierarchy View – Breakdowns by organizational layers

3. Employee Details – Absence data per employee

Each section supports filtering, exporting, and deeper drill-down for detailed insights.

Overview Tab

The Overview tab provides a snapshot of overall absence activity within the selected timeframe.

Headline Metrics

Included at the top of the dashboard:

• Total absence hours

• Absence employees (unique employees with at least one absence)

• Number of absences

• Avg. absence hours per employee

• Avg. absence hours per absence entry

These metrics help you quickly assess the scale and distribution of absence events across your workforce.

Absence Hours Over Time

This chart visualizes overall absence behaviour across the selected period. It includes:

• Total Absence Hours (line)

• Unique Employees (columns)

You can spot peaks, recurring patterns, or quiet periods.

Absence Hours by Leave Type

A grouped bar chart showing total absence hours grouped under broad leave types such as:

• Personal

• Sickness

• Vacation

Helpful for seeing which types contribute most to total absence time.

Absence Hours by Leave Type Over Time

Shows trends in the three major leave categories over the selected time period.

Absence by Leave Reason

A detailed table that breaks down:

• Total Absence Hours

• Absence Count

• Unique Employees

• Leave Reason Type → Leave Reason

This table reveals exactly which reasons (e.g., Sick Leave, Holiday) drive absence hours.

Absence Hours by Leave Reason Over Time

A time-series trend of detailed reasons such as:

• Childcare Leave

• Holiday

• Medical Appointment

• Resting

• Sick Leave

Hierarchy View Tab

The Hierarchy View allows you to analyze absences by organizational structure:

Tenant → District → Unit → (Section) → Employee

Absence Hours per Leave Type Overview

This summary table shows:

• Avg. absence hours per employee

• Total absence hours

• Leave Reason Type (Personal, Sickness, Vacation)

Values can be grouped by:

• District

• Unit

• Section

You can right-click to drill further into any hierarchy level.

Bubble Charts: Absence Hours by Level

These charts plot:

• Total Absence Hours (x-axis)

• Avg. Absence Hours per Employee (y-axis)

• Bubble size = number of absence events

Available charts:

• Absence hours – district

• Absence hours – unit

• Absence hours – section

• Absence hours – employee

These visuals help identify high-impact teams or individuals.

Absence Hours Over Time (Hierarchy)

Trend charts for:

• Total Absence Hours by district

• Total Absence Hours by unit

These allow comparison of organizational performance over time.

Employee Details Tab

The Employee Details view lists every employee with absence hours in the selected timeframe.

Data columns include:

• Badge Number

• Unit Name

• Section Name

• Leave Reason Type / Total absence hours in each category

  • Personal

  • Sickness

  • Vacation

This table is limited to the first 500 rows for performance, but can be filtered down for easier navigation.

Use this tab to:

• Investigate frequent absentees

• Review absence patterns for individual staff

• Support coaching or absence management conversations

Practical Use Cases

1. Identify High-Absence Units

   Use hierarchy charts and metrics to find teams with unusually high absence levels.

2. Explore Leave Type Patterns

   Identify whether sickness, vacation, or personal leave contributes most to total absence hours.

3. Detect Seasonal or Weekly Trends

   The time-series charts show whether certain weeks or seasons consistently produce higher absence.

4. Support Workforce Planning

   Use trends to anticipate staffing shortages and adjust scheduling or resources.

5. Conduct Employee-Level Investigation

   Employee Details lets you examine individual absence patterns for coaching or Compliance.

6. Monitor Policy Effectiveness

   Track changes in specific leave reasons over time following HR policy updates.

Conclusion

The Absences Dashboard provides managers and HR leaders with essential insights into employee availability, leave behaviour, and organizational patterns. With its flexible filters, visual breakdowns, and detailed employee-level records, it helps you better understand and manage absenteeism to maintain healthy staffing levels and operational stability.