Display Statistics in Schedule

Updated by Daniel Sjögren

Select Statistics under the Display option in Schedule to see standard variables, and if applicable optimal headcount and Forecast variables.

This article is about Standard variables. Please see more information about optimal headcount and Forecast variables here.

Standard variables

Standard variables are variables that Quinyx calculates based on configuration of the system mainly around schedule, punches and absences. See below definition all all standard variables that we support:

Name

Definition

Options/Settings affecting the calculation

Scheduled hours incl. absence

Scheduled hours with or without breaks including scheduled hours covered with an absence, plus unassigned shifts.

  • Agreement > Break rules and schedule changes - "Calculate breaks as working time" (yes/no)
  • A) shift type advanced settings, or B) shift advanced settings - "Count as scheduled hours" (yes/no)
  • Tables > Absence reason type > "Counts as worked hours" (yes/no)

Scheduled hours excl. absence

Scheduled hours with or without breaks excluding scheduled hours covered with an absence. Note that unassigned shifts are counted as well, plus unassigned shifts.

  • Agreement > Break rules and schedule changes - "Calculate breaks as working time" (yes/no)
  • A) shift type advanced settings, or B) shift advanced settings - "Count as scheduled hours" (yes/no)

Productive hours

Scheduled hours with advanced setting "Productive hours" excluding hours covered with an absence.

  • Agreement > Break rules and schedule changes - "Calculate breaks as working time" (yes/no)
  • A) Shift type advanced settings, or B) Shift advanced settings
  • "Count as productive hours" ("Yes, Always", "Yes, for scheduled hours") (yes/no)

Worked hours incl. absence

Worked hours including scheduled hours covered with an absence.

  • Agreement > Break rules and schedule changes
  • "Calculate breaks as working time" (yes/no)
  • A) shift type advanced settings, or B) shift advanced settings
  • "Count as worked hours" (yes/no) - Tables > Absence reason type >
  • "Counts as worked hours" (yes/no)

Worked hours excl. absence

Worked hours excluding scheduled hours covered with an absence.

  • Agreement > Break rules and schedule changes
  • "Calculate breaks as working time" (yes/no)
  • A) shift type advanced settings, or B) shift advanced settings
  • "Count as worked hours" (yes/no)

Absence hours

Scheduled hours covered with an absence.

  • A) shift type advanced settings, or B) shift advanced settings
  • "Count as scheduled hours" (no)

Actual salary cost

Actual salary cost calculated from salary types generated from punches and absences

Note: Business daybreak is taken into account.

Salary types: (punches and absences)

  • Account settings > Agreement templates > Salary types > Salary cost (value) > "Salary cost type" (selection)
  • Account settings > Agreement templates > Salary types > Salary cost > "Include in total cost" (yes/no)
  • Tables > Absence reason types > Absence type > "Salary basis" (yes/no)

Expected salary cost

Expected salary cost based on actual salary cost up until this full hour from start of selected period plus scheduled salary cost from this full hour until end of selected period

Unassigned shifts:

  • Shift types > "Hourly cost" (value)
  • Shift types > "UT1", "UT2" etc (value)

Assigned shifts:

  • People > Agreements > Salary (hourly /monthly cost) (value)
  • People > Agreements > Social costs (value) -
  • People > Agreements > Salary adjustments > "Social adjustments", "Years worked" "Personal additional salaries" (value)

Salary types: (punches and absences)

  • Account settings > Agreement templates > Salary types > Salary cost (value) > "Salary cost type" (selection)
  • Account settings > Agreement templates > Salary types > Salary cost > "Include in total cost" (yes/no)
  • Tables > Absence reason types > Absence type > "Salary basis" (yes/no)

Expected salary cost (business day)

Expected salary cost based on actual staff cost up until business daybreak plus scheduled staff cost from business daybreak until end of selected period.

Unassigned shifts:

  • Shift types > "Hourly cost" (value)
  • Shift types > "UT1", "UT2" etc (value)

Assigned shifts:

  • People > Agreements > Salary (hourly /monthly cost) (value)
  • People > Agreements > Social costs (value) -
  • People > Agreements > Salary adjustments > "Social adjustments", "Years worked" "Personal additional salaries" (value)

Salary types: (punches and absences)

  • Account settings > Agreement templates > Salary types > Salary cost (value) > "Salary cost type" (selection)
  • Account settings > Agreement templates > Salary types > Salary cost > "Include in total cost" (yes/no)
  • Tables > Absence reason types > Absence type > "Salary basis" (yes/no)

Scheduled salary cost incl. absence

Scheduled salary cost calculated from unassigned and assigned shifts incl absence shifts until end of selected period.

Unassigned shifts:

  • Shift types > "Hourly cost" (value) - Shift types > "UT1", "UT2" etc (value) Assigned shifts:
  • People > Agreements > Salary (hourly /monthly cost) (value) - People > Agreements > Social costs (value)
  • People > Agreements > Salary adjustments > "Social adjustments", "Years worked" "Personal additional salaries" (value)

Salary types: (absence shifts)

  • Account settings > Agreement templates > Salary types > Salary cost (value) > "Salary cost type" (selection)
  • Account settings > Agreement templates > Salary types > Salary cost > "Include in total cost" (yes/no)
  • Tables > Absence reason types > Absence type > "Salary basis" (yes/no)

Scheduled salary cost excl. absence

Scheduled salary cost calculated from unassigned and assigned shifts excl absence until end of selected period.

Unassigned shifts:

  • Shift types > "Hourly cost" (value) Shift types > "UT1", "UT2" etc (value)

Assigned shifts:

  • People > Agreements > Salary (hourly /monthly cost) (value) - People > Agreements > Social costs (value) - People > Agreements > Salary adjustments > "Social adjustments", "Years worked" "Personal additional salaries" (value)
Only schedule items taking place on the current group are included in the statistics - for instance, shifts taking place on other units are not included.
Statistics display schedule items and employees regardless of whether or not a given employee has an active role.
Standard variables are currently not accessible through API:s. We may revisit this in the future, so stay tuned!

Summary

Sum of each variable for the selected period.

Table

Variables can be broken down per day, or in daily view, and per hour.

Since some of the variable names in statistics are quite long, we've added tool tips so that you can see the full name on hover. 

Graph

Variable broken down per hour in daily or weekly view and per day in monthly view.

The variables are divided based on unit 1) hours and 2) sales and cost. Depending on which variables you have selected (pen), you will therefore be able to see one or two graphs.

Graph data points display on a day level when more than one day has been selected.
Note that if you use input data with both units, you can decrease the height of the statistics by clicking the "arrow" appearing at the top of the statistics. You will still be able to see both graphs, but you will have to scroll.

If you want to view more details, you can hover over the graphs and you see the data data and hour. 

Pen

The pen allows you to select which variables you want to display statistics for. You only need to set this up once as it will be remembered until next time.

Refresh variables 

The variables in the statistics will no longer be automatically refreshed when the user makes a change in the interface; you will need to manually trigger the refresh by clicking on the refresh icon in the statistics:

As an example, if you filter in the schedule view, you will need to refresh, so that the data can be refreshed based on your filter selection. 

When the data is out of sync, i.e., not updated, the statistics will be grayed out. Click refresh and the data will be updated: 

Note that specifically when date span and/or view mode (day/week/month/custom etc) is changed, the statistics will update automatically.

Remember variable selection

When you have selected which variables you want to see in Base schedule, your selection is remembered for next time.

The statistics selection (both in Schedule and Base schedule) is remembered per user and account, so if you have access to multiple accounts, then you can now have different selections on different accounts.

How to set up standard variables

It's possible to decide which standard variables that should be visible in the Schedule view. If you are a account manager (system admin), go to Account settings and Variable settings. There you can decide which standard variables that should be visible in the Schedule view for the whole organization.

Only schedule components that are on the current group are counted in the statistics, shifts taking place on other units are not included in the calculation.


How Did We Do?