Statistics in base schedule

Updated 2 weeks ago by Leigh Hutchens

Select Statistics under the Display option in Base schedule to see standard variables, and, if applicable, Optimal staffing and Forecast variables as well.

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

Note that the variables in Base schedule (except for Base schedule hours-variable), aren't a calculation of the hours in Base schedule, it’s a calculation of the hours in the Schedule. The idea is to use the variables as a reference when building your Base schedule. 

Standard variables

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

Name

Definition

Options/Settings affecting the calculation

Base schedule hours

Schedule hours in the Base schedule.

This variable is enabled by default in Variable settings, but users will need to go in under "the pen" in the statistics in base schedule and activate it to be able to see it in the statistics. Note that you need to turn the variable on in the column "Schedule" in the Variable settings page, although the variable is only shown in Base schedule.

  • Agreement > Break rules and schedule changes - "Calculate breaks as working time" (yes/no)

Base schedule salary cost

Salary cost calculated from assigned and unassigned shifts from the date selected in the base schedule statistics. Note that this variable only includes cost generated from the specific base schedule.

Click here to read more about setting up base schedule salary cost.

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)

Scheduled hours incl. absence

Scheduled hours with or without breaks from assigned and unassigned shifts 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 scheduled hours" (yes/no)
  • Tables > Absence reason type > "Counts as worked hours" (yes/no)

Scheduled hours excl. absence

Scheduled hours with or without breaks from assigned and unassigned shifts 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 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.

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.

More about base schedule salary costs

If set up in Quinyx, you can see salary cost for the shifts in base schedule.

Given that you have at least read access on salary permissions, you'll be able to turn on this variable in the statistics in base schedule. Under Account settings > Variable settings, this variable is turned on by default. If you don’t want your users to have it as an option in the base schedule drop-down menu, you can turn it off under Variable settings. Note that you need to turn the variable on in the column "Schedule", although the variable is only shown in Base schedule.

Note that if the user has “no access” on permission “Salary”, they won’t be able to see any cost at all in Quinyx. 

How does Quinyx calculate this variable? 

Quinyx calculates the cost based on the date selected in the base schedule statistics and simulate what a shift would cost on that particular date.

Note that we don’t include shifts already in the schedule or in other base schedules, we only calculate what the cost will be in the particular base schedule template. 

Summary

Sum of each variable for the selected period.

Table

Variable broken down per day, or in daily view, 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.

Note that if you select a date in this date picker, the statistics displayed will stay on that specific date if you switch base schedule day/week.
It's not possible yet to configure the variables in Base schedule under variable settings.
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.

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: 

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 Did We Do?