Employee metrics in Schedule

Updated 1 month ago by Leigh Hutchens

View employee metrics

To easily view employee metrics, click the ellipsis next to the employee avatar and name, followed by “Employee metrics”. As this panel loads, a loading indicator will appear. This panel appears to the left of the ellipsis menu, but you can move it around. You can expect the same behavior from this panel as you can from the “Add shift” and “Edit shift” panel. The top of the panel contains the name of the employee in question. If you, for instance, were to delete/move the shifts of the employee whose metrics you’re viewing, you can use the refresh button at the top-right of the panel.

You can view scheduled, worked, and expected hours versus nominal ones. For each variable, Quinyx displays hour count, difference between the two (formula: scheduled or worked or expected hours minus nominal hours), and percentage (formula: scheduled or worked or expected hours divided by nominal hours). The difference displays in red if negative, just as in the list of employees in the left-hand margin of the schedule. Due to popular request, we display the actual names of the variables and not icons with tooltips. 

The panel contains the above metrics information for the selected period, the schedule period, and the balance period (if applicable). Each one of these periods is contained in an accordion. Each period then features one accordion per agreement. Since there is always only one selected period, that specific accordion always displays dates. There can, however, be multiple schedule and balance periods within a selected period. For this reason, the agreement accordions in the schedule and balance period accordions will contain one dated accordion per schedule or balance period (see above screenshot). As you open the panel, all accordions except for the dated accordions in schedule period and balance period; for those accordions, only the first one will open by default.

It’s data for the schedule period and balance period taking place at 00:00 of the first date of the currently viewed period that displays by the avatar, as well as in the top schedule period and balance period dated accordions in the metrics panel. This is especially worth noting for those of you that in People > Staff card > Advanced setting categories > Rules for working time  > Daybreak daily rest have configured another value than 00:00.

Quinyx offers support for an employee having multiple agreements, which is beneficial either when the same employee holds different positions that come with different employment rates and salaries, or as a way to manage their picking up extra shifts. If an employee has multiple agreements in Quinyx that are valid at least one day in the period currently viewed in Schedule, then the Employee metrics panel will display the metrics for each agreement in its own accordion for each dated period. Depending on the amount of agreements your employee has, you can expect slower loading of the panel than for employees with only one agreement.

Note that an agreement can be set as preferred for a certain unit in People > Agreement > Agreement details in Neo, which requires the employee to have been configured as sharable in the Units tab in Classic’s staff card. This feature is convenient if the employee has a role on multiple units and you want different agreements to be used based on which unit the employee is working on. The Employee metrics panel will display the name of that preferred unit (see “Drottninggatan” mention in the above screenshot).

For each dated period, multiple agreements will be sorted in the following order:

  • Main agreements are always displayed first.
  • For secondary/non-main agreements, the sorting is by agreement start date from earliest to latest start date.
  • If there are multiple secondary/non-main agreements with the same start date, then alphanumerical sorting is applied.

The main agreements are color-coded the same way they are in People; main agreements appear against a dark blue badge whereas secondary agreements appear against a turquoise one.

Employee sorting

The default sort order of the schedule, except for unassigned shifts, is the shift's start time. The shift that starts earliest is at the top of the schedule. You can easily change the sort order by clicking on the sorting drop down menu.

  • Start time
  • Employee Name A-Z
  • Employee Name Z-A
  • Diff. of metric data in calculation period

Employee metrics calculation period

You can determine for which period the employee metrics for all of the employees in the left-hand margin of the Schedule should display.

The selectable periods are:

  • Selected period: This is whatever period you’re currently viewing in Schedule.
  • Schedule period: This is configured in Agreement > Agreement template.
  • Balance period: This is configured in Agreement > Agreement template.
Quinyx will remember your selection if you leave the view and come back, nor if you switch period.

When it comes to the way agreement workdays are translated into nominal hours and you’re looking at the metrics of a specific day, the same principles apply in schedule as in Base schedule:

  • If workdays are configured to 7, Quinyx considers every day as a workday.
  • If workdays are 6, Quinyx considers Monday to Saturday as workdays.
  • If workdays are 5, Quinyx considers Monday to Friday as workdays.
  • If workdays are less than 5, Quinyx currently lacks support for determining which weekdays are workdays. Therefore, for instance, if workdays are 4 and nominal hours 21 in the agreement, then the nominal hours of any day you’re looking at will display as 21.

As you move between different days or weeks in your base schedule, Quinyx remembers the selected calculation period. However, as you leave the schedule and come back, your calculation period selection will reset - we of course plan to improve this in the releases to come.

The nominal hours displaying in the employee metrics are currently always for the main agreement only. This means the system goes by the number of workdays defined on the agreement that’s configured as main agreement as of today’s date.

Metric display mode in Schedule

In the Employee list display options, you can configure how to display agreement metrics under the “Metric display mode” heading:

  • Totals
    • This displays the totals for scheduled hours and nominal hours across agreements.
    • Note that if there are parallel agreements that have different schedule or balance periods, and schedule period or balance period respectively is selected as metric calculation period, a badge saying “Different periods” will appear here since summing them would be misleading.
    • Note that if you’re following up on overtime or additional time over a period for instance, using the totals mode won’t correctly reflect the calculation of what’s shown in the Time card and on what’s being transferred to payroll in the specific case you’re got an agreement change in the period you’re looking at since Quinyx' calculation for that is made by agreement. So, for following up on these sort of things, we recommend you use the “By agreement” display mode which correctly reflects that specific case.
  • By agreement
    • This displays the scheduled hours and nominal hours as one row per agreement. Just as in People and the metrics panel, main agreements are color coded dark blue and non-main agreements are color coded turquoise.
    • When the “Diff. of scheduled/nominal hours in calculation period” sorting option is selected, the actual sorting of employees in the left-hand margin is still done according to hours across agreements.

In both of the above cases, the metrics by the employee avatar now also display with a percentage sign indicating the percent of nominal hours that are currently scheduled. In some cases, the percentage doesn't appear fully - we'll address this shortly.

Quinyx currently doesn’t remember your selection of metric display mode if you leave the view and come back. However, Quinyx will remember this (and much more) in a future release, so keep reading our release notes! 

Metric

Scheduled hours/Nominal hours

The metric scheduled hours vs. nominal hours displays the amount of scheduled hours in the time period (If breaks are set to count as scheduled hours in the agreement, they will be included here) vs. the number of nominal hours in an employee's agreement.

Worked hours/Nominal hours

The metric worked hours vs. nominal hours displays the amount of actual worked hours vs. the nominal hours in an employee's agreement.

Expected hours/Nominal hours

The metric expected hours vs. nominal hours is particularly useful if you want to ensure employees are meeting their basic nominal hours requirement as defined in their agreement.

  • Before a shift starts, "Expected hours" will show the same as "Scheduled hours".
  • But for an ongoing shift that has an open time punch, "Expected hours" will show "Worked hours", i.e. hours punched up until the current moment.

Worked/Rolled out hours

The metric worked hours vs. rolled out hours is particularly useful for those of you aiming to use base schedule as an overtime method, but it's also useful for anyone wanting to follow up on an employee's worked hours in regards to rolled out base schedule hours.

The data used in worked hours is the exact same as the ones in the worked hours vs nominal hours metric. The data used in the rolled out hours is a snapshot of all the base schedule shift hours of the latest rollout of any one base schedule rolled out for the given employee. 

A few details regarding the rolled out hours:

  • This metric considers bank holidays reduction bank holiday setting, which can be configured to anywhere between 0% and 100%. In order to not defeat the purpose of considering that setting, the metric doesn’t consider the “Schedule bank holidays” agreement setting.
  • This metric considers the “Count as scheduled hours” setting on shifts/shift types, as well as the “Calculate breaks as working time” agreement setting.
  • The data reflects the period you’re viewing the metric for (selected period / schedule period / balance period), just like with the other metrics.
Example scenarios

As we've received a great deal of questions regarding the expected behaviour, we're describing how it works below. Please note that not all the below cases are anything you want to do regularly, we're just describing many different scenarios, including corner cases, so it's clearer to you what to expect and not.

  • If you roll out 10 scheduled hours on a bank holiday configured to 70% reduction, then this will count as 3 hours towards the rolled out hours endpoint.
  • If the employee has a base schedule but it hasn’t been rolled out, rolled out hours will be 0.
  • If you roll out a base schedule, delete the rolled out shifts in Schedule and then re-rollout the same base schedule over the same period using the same base schedule weeks across the same dates again, the rolled out hours metric will update to reflect what the base schedule looked like at your last rollout.
  • If you roll out a base schedule, make a copy of that base schedule and roll that one out as well, then the rolled out hours metric for any one employee will double.

Worked hours/Scheduled hours

When you apply the Worked hours/Scheduled hours metric, the employee KPI will display how many worked hours versus scheduled hours for all employees there are in the chosen period. This enables managers to quicly make sure that your employee is working according to the schedule.

Count logic for employee metrics in Schedule

With regards to daybreaks

Prior to version 0107, the employee metrics in Schedule counted and displayed data from Time-daybreak to Time-daybreak for any given employee. By Time-daybreak, we’re referring to the value in the Daybreak field in Agreement > Advanced setting categories > Time > Rules for time punching > Daybreak. In the below example, user Gregory Payne has Time-daybreak 01:00, and as you can see, only the hours prior to 01:00 in the selected period of Monday May 3 are counted in the employee metrics:

As you can see in the Time card, the issue is that if you were to transfer only this date to payroll, you would transfer 3.5 hours and not 0.5.

The reason for this logic in the Time card is that when transferring to payroll, Quinyx will transfer the hours of all shifts starting prior to the Time-daybreak of the transferred dates. The employee metrics are to help you keep track of hours, and ultimately, to mitigate additional time and/or overtime compensation - meaning this mismatch between the metrics and the Time card / payroll outcome has been suboptimal when there are shifts crossing the Time-daybreak.

So, in order to better take into account the calculations performed by Quinyx when running payroll, the employee metrics in Schedule now instead count and display the hours of all shifts starting prior to the Time-daybreak. This means now, for the same user, Time-daybreak, date, and shift, get this result:

We’ve explained the above changes using the employee metrics’ “selected period”, but the same change applies to “schedule period” and “balance period” in those same metrics. Any warnings about nominal hours, weekly hours, etc., now also take this new count logic into account.

The above only applies to Schedule.

With regards to same-agreement changes

Note that specifically when you make same-agreement, date-controlled changes to employment rate during a schedule period/balance period, the metric will still appear as one period. However, in the Time card and payroll file, you’ll find that Quinyx splits the overtime/additional time/minus time into one calculation period before the change of employment rate and one after. For this reason, we recommend you limit same-agreement changes to employment rate to the first or last day of the schedule period/balance period if you use any of those as calculation period for overtime/additional time/minus time. When you make same-agreement, date-controlled changes to salary, the above-described split doesn’t occur, so one only needs to be mindful with same-agreement employment rate edits.


How Did We Do?