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.
Hey @all,
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.
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.
Page 1 / 1
Hi @StevenB,
welcome back to our community!
Probably this filter will help you out:
FILTER YEAR ( PU_FIRST ( Case Table, Activity Table.EVENTTIME, Activity Table.Activity Column = Technisch abgeschlossen ) ) = YEAR(TODAY())
If you need further support feel free to reach out to us again!
Best,
Justin
Great. thx a lot.
Greedings from Germany
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.