Skip to main content
All CollectionsIndigo People Insights
Leave Balance & Sick Leave Analysis in People Insights
Leave Balance & Sick Leave Analysis in People Insights

All about the premium dashboards for Leave Balances and Sick Leave Analysis in Indigo's People Insights module

Marie Claire Saliba avatar
Written by Marie Claire Saliba
Updated over a month ago

Leave Balances

View Vacation Leave and/or Sick Leave data to track trends and help you with resource planning. Filter the data as needed from the options in the top of the dashboard—by Year, Leave Group, Leave Type, and Department or Cost Centre.

The data is shown in four charts:

  • Actual Leave Taken (hrs) vs Target Entitlement: compare at a glance what percentage of leave your employees have used versus the target leave percentage.

    • Choose to include or exclude future leave hours from the 'Excluding Future Hours switch on the left, under the chart's title.

    • Set the target leave percentage from the right dropdown menu in the top right of the chart.

    • Filter actual leave taken versus target leave using the slider at the bottom of the chart.

    Any employees that have used more than the target leave percentage will be shown in red.

  • Number of Employees by Department: a bar chart showing how many employees you have per Department (or Cost Centre, depending on the filter selected), and the total number of employees in the top right of the chart. The number of employees without leave entitlement are shown on the right, in grey, below the figure for Total Employees.

  • Actual Leave Used % by [category]: view data on the average percentage of leave used, and drill up or down as needed. Change the data category any time from the dropdown in the chart's title.

  • Actual Leave used % across years: this visual shows the leave percentage used across the years. Pick a data point from any of the other charts to have this graph show how the specific selection's leave percentage compares to the whole company's.


Sick Leave Analysis

Use this dashboard to view and analyse sick leave trends. Filter by Company, Year, Leave Type, Leave Group, and by Department or Cost Centre.


The data shows in seven charts:

  • Date and % of Employees Sick/Sick Leave Hours: this graph shows the percentage of employees who were sick for a particular date. You can filter the dates using the slider at the bottom of the graph.

  • Sick Leave by Month: view the number of days and sick hours per month in this graph.

  • Employee by Hours/Bradford Factor:

    • Bradford Factor: the default view, this chart functions based on the Bradford Factor.

      • This is a time-tested method for HR to keep track of sick leave occurrences and spot patterns that may highlight a need for investigation.

      • It is calculated using the formula S² x D = Bradford Factor.

        • S is the number of separate instances that an employee was sick.

        • D is the number of sick days an employee has used over a 52-week period.

    • Hours: selected from the dropdown menu, this bar chart shows the number of sick leave hours for each employee.

  • Analysis by % of Total Hours/Avg. Hours: This section is made up of 3 charts—By [category], By Day Name, and Avg. Hours by Department/Cost Centre. View the analysis by average hours or by percentage of total hours, selecting what you need from the dropdown in the chart's title.

  • % of Sick leave used by year: this chart shows the percentage of sick leave used by year for any selected data points and for the company. It can be filtered to show either Full Pay or Half Pay (when neither button is selected, values shown are for both).


Related Articles:

Did this answer your question?