My goal is to count on a daily basis how many cases were between two specific activities on that day. See the following example:
So the result table needs to include every day in the timeframe (GENERATE_RANGE?). For each day I count all connections where “day” lies in between “Start” and “End” of the connection.
Is this possible in Celonis?
Thanks for any ideas,