Feature of the week series #6 - Factory Calendar


Dear Celonis Community!

In this series, we present you every week handy features like sharing selections or clustering variants.

This week’s feature is the new and often requested Factory Calendar, available in the IBC and Celonis Process Mining 4.5.

The Factory Calendar is a table where you log real work hours. You can now use this table to calculate net throughput times, so only the time between two activities that you actively worked. In this demo, we show you how you can set it all up:

Here you can click through the Analysis to compare the KPIs. The used Eventlog looks like this:


And this is how the Factory Calendar looks like:


To set up the Factory Calendar, you can just upload (for example via File Upload) and add it to your Data Model in the above format. You don’t need to link it to other existing tables in your Data Model. Here you can see how easy it is to setup the Factory Calendar in the IBC:

Happy Process Mining!
Your Celonis Product Team

1 Like
Feature of the week series #7 - Worldmap
Feature of the week series #8 - IBC Contextual Help Center
pinned globally #2

Dear m.kohl,

Thanks for sharing this information.
I have a question concerning factory calender. In case you have factories in more then one country for example US and China or elsewhere in Europe, we have in SAP different factory calenders for each country. Is such a setup possible (the factory itself is present in the dataset)?

Have fun!


Dear Hans,

Yes, you can work with multiple Factory Calendars. You can either just upload multiple calendars and reference them individually in your PQL statement. Or you can merge your Factory Calendars into one table, with an additional column as factory identifier (e.g. „US_1“, „EU_1“, …). This identifier can then be referenced as filter condition in the below statement:

FACTORY_CALENDAR ( table.start_date_column, table.end_date_column [, filter_condition ] )

In your case the filter condition would look like this: calendar.factoryID = ‘EU_1’

Kind regards,

unpinned #5

is it possible to set up our own factory calender (we do not use SAP for Celonis) and maybe you could give some hint how.

Thank you!



Hi Maria,

yes you can. How does your calendar look like? Can you store intervals as shown in the post at the top?

Kind regards,


so u basicaly Need a csv file with above format? i am a bit confused About the case_ID in the factory calender. What is it in this case?



Hi Maria,

you are right you just need to add such a file to your datamodel. You don’t need to link any foreign keys for this table. The name of the first column above is in fact misleading. It does not represent the Case ID of your process. It can be anything you chose and will only be used as filter column (if you wish so) in the Remap_Timestamps function. That means, you have the option to only select certain intervals in your factory calendar. You chose these intervals by entering the value of this filter column into the Remap_Timestamp function.
Cheers, Max

1 Like