All Collections
Add-ons: Insights, Papershift HR and more
Insights
Report on the number of days worked in the past month
Report on the number of days worked in the past month
Kevin Bendixen avatar
Written by Kevin Bendixen
Updated over a week ago

Want to know the number of days your employees worked in the past month? With our Insights module, you can easily create the necessary reports. You only need to create the required metrics once and then you can view the latest report every month.

Create metrics

First, you need to create a combined metric:
Click on the gear icon (Settings) in the left navigation bar → Location settings → Click on the "Reports" tab → Click on the "New combined metric" button under "Combined metrics"

Creating combined metric

In the newly opened window, you can now name the metric. Select "Actual" for both metric 1 and metric 2 and "Metric 1 / Metric 2" for the operation. This creates a value of 1 for each day worked (for example, 8 hours worked divided by 8 hours worked equals 1). Additionally, check the box "Convert empty values to 0".

Generate the report

Using the combined metric you created, you can now create the report. Click on the graph icon (Reports) in the left navigation bar.
You can create a new report by clicking the plus button in the upper right corner.

Create the report

In the new window, click on "Add metric" to load the metric you created in step 1. Under Data, you can specify whether the report should only evaluate the data of certain workspaces, tags or employees. By default, all data is selected.

Second part of creating the report

For "Period", select "Last month", and each worked day of the past calendar month will be evaluated. To get the data per employee and month, select "Employee" in the "Grouping" section, and "Month" in the "Presentation & Interval" section. After confirming with the "Done" button the report will be created.

It should look something like this:

Finished report
Did this answer your question?