Hey all,
Is there a way to filter out all cases that start before a certain year?
I tried the following:
FILTER YEAR(P2P_-_Q2_2018_csv.TIMESTAMP) => 2016
But this still gives me cases that start in 2015 in an OLAP table, because there are also activities performed in 2016.
Hi Jasper,
Do you have a case table in your data model? If so, you can try to use the pull up functionality to look for the first event in each case, and state that this first event should be in 2016 or later. Your code would then be:
FILTER YEAR(PU_FIRST(<Case_Table_Name>, P2P_-_Q2_2018_csv.TIMESTAMP)) => 2016Note that you dont have to specify a column in the case table, only the case table name itself. For more information, check the PU_FIRST documentation:
https://help.celonis.cloud/help/x/44ZRAQ
Bests,
Jan-peter
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.