While creating a sheet in Celonis studio(free plan), is it possible to filter cases based on when they start/end? When I try to filter by time range, it gives cases which are active in that range, but not necessarily entirely contained in the range.
Question
Filtering by date
Hello,
You can try with filtering by using combined PU_FIRST("<YOUR_CASE_TABLE>","<YOUR_ACTIVITY_TABLE>"."EVENTTIME") AND PU_LAST("<YOUR_CASE_TABLE>","<YOUR_ACTIVITY_TABLE>"."EVENTTIME"), or throughput time selection using "Process Start" and "Process End".
Best Regards,
Mateusz Dudek
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.