I need a filter that looks at the event time of the activity I am looking for.
With this filter I can determine my KPI worklist.
At the moment i have a filter, but the wrong filter.
For Example.
image984209 7.49 KB
In this picture we can see my Celonis activity table. (ID activity timestemp)
In my other table AUFK I have the column ERDAT in which i can see the start date of my order -->(28.Feb.2019 07:51:48)
My actually FILTER YEAR(AUFK.ERDAT) = Year(Today()) keeps the Start date of my ID 6254008060 with the activity Erffnet.
But I need the timestemp Technisch abgeschlossen for my filter.
> FILTER YEAR("timestemp from technisch abgeschlossen) = Year(Today())
On this example the Year is the same, but I have enough IDs where the start Date ist in 2018 and the activitity technisch abgeschlossen is in 2019.
That means I could get rid of AUFK.ERDAT and use directly the timestamp of my activity table.
But I dont know the Function. Pls can u help me.