Not sure if I understood your question completely but looks like your are trying to calculate time between scheduled time (from scheduled Date) and actual (from event Date)?

---

Sorry yes, throughput time between a column date in a table (scheduled date) and an event time for an activity (actual date) - we could script scheduled date as an activity but I wonder if there is a way to manage this via the analysis.

Thanks

Oliver

---

Hi Oliver,
It sounds to me that a simple OLAP table is the only thing you need. To show the difference per case, use the following settings:
Dimensions:

1. Case ID
2. Scheduled Date Column (for verification)
3. Actual Date Column (for verification)
4. DATEDIFF(ss, Scheduled Date Column, Actual Date Column)

To highlight cases that are for instance too late in your analysis, use the following filter:
FILTER DATEDIFF(ss, Scheduled Date Column, Actual Date Column) > 0.0
Note that ss here stands for seconds, and will return the time difference in seconds. For more information and other time unit notations, see the documentation: https://help.celonis.cloud/help/x/-YZRAQ

---