The data model Calendar which days and hours to take into consideration in throughput time calculation. For accurate throughput times, your company's working hours and days. 

Celonis provides two calendars: Throughput Time Calendar and Factory Calendar. 
Click on the toggle of any calendar to get more information and a detailed description.

After the configuration of any calendar, the WORKDAYS_BETWEEN function will be available in the Process Explorer, the Variant Explorer as well as in the Process Explorer KPIs.


Throughput time calendar

Use the throughput time calendar to manually define your working days to be considered in any throughput time calculation. The throughput time calendar will define your working days and hours without a database triggered calendar.

  1. Toggle: activates/deactivates the throughput time calendar.

  2. Choose preset: select a pre-defined calendar templates using the dropdown menu. The presets will automatically fill the working days and hours below according to the selected template. 

  3. Working days column: select the days in which work is done. 

  4. Starting hours: select the hour of the day in which the work begins

  5. Ending hours: select the hour of the day in which the work ends.

  6. Reset: resets the calendar input to the default (no working days and hours assigned).




Factory calendar

The factory calendar is used to define working days between two dates based on your data source. 

  1. Toggle: activates/deactivates the factory calendar.

  2. Choose database: select a database that includes your time specification.

  3. Choose calendar table: select the table with the calendar from the database above.

  4. Choose calendar ID column: select the column of the calendar ID in the calendar table above.

  5. Calendar table structure: the following table displays as reference the structure that the imported calendar table must follow in order for the Factory calendar to work. In the 'Month' column, the 0 represents a non working day, while the 1 represents a working day. 

  6. Choose calendar ID: select the calendar ID column from the case table.


  • No labels