Hi All,As we have a calendar feature in Throughput Time Search Component, such that we can include/exclude weekends,Do we have same kind of feature in in-built sheets like Conformance checker, Process Explorer, with include/exclude weekends ?

If YES, please help us on this

Page 1 / 1

I recommend using a Sheet filter that excludes Saturdays and Sundays from your analyses (like Process Explorer and conformance checker)

Your filter looks like this would like like this:

FILTER DAY_OF_WEEK("ACTIVITIES_TABLE_PO"."EVENT_TIME") NOT IN (0,6);

NOT IN (0,6) means we exclude Sunday and Saturday from the analyses respectively.

Simply replace the "ACTIVITIES_TABLE_PO"."EVENT_TIME" with your own table and event time column and you should be good 😁.

Let me know if you encounter any issues.

Kind regards,

Sverre Klein

I recommend using a Sheet filter that excludes Saturdays and Sundays from your analyses (like Process Explorer and conformance checker)

Your filter looks like this would like like this:

FILTER DAY_OF_WEEK("ACTIVITIES_TABLE_PO"."EVENT_TIME") NOT IN (0,6);

NOT IN (0,6) means we exclude Sunday and Saturday from the analyses respectively.

Simply replace the "ACTIVITIES_TABLE_PO"."EVENT_TIME" with your own table and event time column and you should be good 😁.

Let me know if you encounter any issues.

Kind regards,

Sverre Klein

Thankyou for your suggestion on my question, I tried applying the sheet filter by using this Query

unfortunately it is not working.

Do you have any other idea?

Thankyou for your suggestion on my question, I tried applying the sheet filter by using this Query

unfortunately it is not working.

Do you have any other idea?

Sorry to hear it didn't work. Can you share more details & a screenshot as of why it is not working?

Sign up