Creating a Line Chart Report

The HRWize Report Builder provides the ability to create reports in different formats:

• Table
• Column chart*
• Bar chart*
• Line chart*
• Pie chart*
• Tile*

* Please Note - These report formats require the HRWize Analytics add-on.

To create a Line chart report, go to:

Reporting > Report builder > New report

Choose 'Line Chart' from Select a report type.

There are many data sources to choose from, but consider that a Line chart report can track changes or trends over short and long periods of time such as time off requests. In this example, we created a Line chart to report on absences for single or multiple time off types. 

So here we have selected Time off period as our data source and give the report a name:

If required, provide a description for the report.

Then, you will need to:

1. Select 'Date' from Select Label Axis.
2. Enter a label name or it will default to the field name if you leave this blank.
3. Select 'Duration' from Select Value Axis.
4. The aggregate will be 'Sum'.
5. Enter a label name or it will default to the field name if you leave this blank.

Next, we want to apply a filter:

Reason

Equals

Personal Days

To make sure only those employees who are active are reported, add a second filter, and select:

Active

Equals

Active

You can check what the report looks like by clicking on 'Edit report' followed by 'View Report'.

This report shows the number of absences per day for each Covid-19 absence with or without symptoms:

In the Select Chart Options section, you can choose 'Order', 'Value', 'Legend', and 'Trend' options which will change the appearance of your chart. Depending on the type and volume of data you are reporting on, these may make little or no difference to your chart. 

The Drilldown option allows you to link this Line chart to another report so you can see more employee detail associated with this report.

1. Select 'Enable drilldown'
2. Select 'Drilldown by clicking entire chart' and then choose 'Drilldown to report' or 'Drilldown to dashboard'
3. Depending on whether you have chosen a report or dashboard, select a report or dashboard you created previously with associated data

1. Alternatively, select 'Drilldown by clicking on a value' then select a report you created previously with associated data.
2. If you have selected 'Drilldown by clicking on a value' then select one or more filters. In this case, we are only reporting on Date so that is the only filter available.

You can check what the report looks like by clicking on 'Edit report' followed by 'View Report'. Here, you can see the report with a Trend line showing in red. In addition, you can hover on any of the data points in the chart to see additional information.

 Depending on how you have chosen to drilldown, either click anywhere on the report or click on any data point, and the drilldown report we linked to will show associated data. In this case, we can see names, department, reasons, etc for all employees absent on that specific day.