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 ?

Hi @ankit.shete12,

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

Hi @sverre.klein11 

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?

Hi @ankit.shete12,

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