The report opens in Excel® format and can then be adapted to your requirements.

tog_minus        Graph Tab

The shades of blue, the Arial text font (28 pt, bold, underlined and centered) and the type of graph (chart) are set by default.

Click to enlarge/reduce

Default dashboard
Click to enlarge/reduce

Customised table

The dashboard can be customised using the various tools available in Excel®:

•        change the character font and size,

•        change the colour fields (plain, graded, etc.) and the background,

•        display a secondary gridline,

•        change the text orientation,

•        add/delete data,

•        change the type of graph (bar graph, line graph, pie chart, etc.).

Influence of the setup on the customisation

01 Yellow 1

File -> Configuration of fixed or variable name tab

DataEx_Kelio Report_Excel perso_Absenteeism rate

01 Yellow 2

Customisation -> Title to be displayed tab

01 Yellow 3

Customisation -> Extraction period tab

01 Yellow 4

Customisation -> Dashboard distribution level tab

01 Yellow 5

Day and time of the edition

01 Yellow 6

Customisation -> Comment to display tab

tog_minus        Dashboard Tab

By clicking on the icn_filter_data_ex and icn_down arrow_data_ex icons, you can access different sort and filter options.

Click to enlarge/reduce

Dashboard Tab
Click to enlarge/reduce

Dashboard with filter Tab

tog_minus        Results Tab

The Results tab allows you to:

•view the number of employees concerned by this report

•view in detail the data that was not registered when the data was extracted

Result of the report with the employee with error