Skip to main content
Question

Filtering by date

  • January 23, 2022
  • 1 reply
  • 21 views
.
Level 3

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.

    1 reply

    D
    Level 2

    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

     

     

    Community Code of ConductAccessibility statement