How do I prepare for absence analysis?

Have more questions? Submit a request


Unless the appropriate data is present, various metrics cannot be shown. Where a sickness is Pregnancy-related, you must tick the relevant checkbox when entering a sickness record.

This section lists the most important areas to check that you are entering the correct data for your Attendance Analyses to work properly.

Working Patterns

Many of the metrics depend on the correct entry and allocation of working patterns, as these determine the working and non-working days of each employee. If these are not set up properly, and assigned to the correct employees, metrics such as Working Days Available, Working Days Lost, etc., won't be correct. In addition, FTE calculations may be affected by your Working Patterns, as described below.


If you want to have analysis of past periods, it's important that the Working Pattern history is correct, so check that employees have the correct Working Pattern assigned not just at the present time, but also for past periods.

Sickness data

Obviously your sickness entries must be complete and correct for your analysis to work, but be aware that there are checkboxes to indicate when an absence is Pregnancy-related, Disability-related, Self-certified or Medically certified (Doctor's certificate). These can all be related to Metrics in your analyses, so make sure they are ticked where appropriate. Also ensure that Include working days only in duration is ticked, so that the Working Pattern is used to calculate the duration of sickness.

Banded Days

The Banded Days are controlled from the Tools menu, under Absence Reporting> Absence Band Set Up. This is where you indicate what counts as short-term and long term absence. Up to seven bands can be defined, and these appear as Analysis Metrics (only the bands that you have specified will be available to be selected as Metrics).


FTE figures can be calculated in several different ways. Ensure that you have specified the appropriate FTE calculation method for each employee before relying on the Absence Analysis FTE figures. A common method is to use the FTE in the allocated Working Pattern, so if you are using this, be sure to check that each Working Pattern has the correct FTE specified, and that the employee Post History Working Pattern child stack (if used) has been set to use the Based upon Working Pattern FTE calculation method, or, if Direct Entry is used, that the entered FTE figure is correct

Articles in this section

Was this article helpful?
0 out of 0 found this helpful