Statistics in Schedule

Updated 1 month ago by Leigh Hutchens

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 > Leave 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 > Leave 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

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 > Leave reason types > Leave 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 > Leave reason types > Leave 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 > Leave reason types > Leave 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 > Leave reason types > Leave 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.

Summary

Sum of each variable for the selected period.

Table

Variable broken down per day, or in daily view, per hour.

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.

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.

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 organisation.

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?