Hi ,
I need a tech support here. Here is the stiation.
I have cases like
Case 123
Activity 1 - Attribute A = X
Activity 2 - Attribute A = Y
Case 231
Activity 1 - Attribute A = W
Activity 2 - Attribute A = Z
Case 321
Activity 1 - Attribute A = Q
Activity 2 - Attribute A = X
Now I need to create an olap table like
CAse 1 -Attrubute A - Case 2
123 ------- X ---------321
because their both Attr. A = X right ?
but how ? I think domain table is not for it.
Best answer by janpeter.van.d
Hi @ömer.petek,
You can use the window functions LEAD/LAG (Window (celonis.com)), to get data from a previous/following table entry at the same row. We used this to see behavior of an follow-up case with the same attributes.
Not sure if it solves your use case (do you only want to display rows with 'X', and what if multiple X's exists?), but I think it is the closest you can get ;)
Kind regards,
Jan-peter
+4Try using the Pivot Table feature in Celonis, for more information kindly find the following link
Try using the Pivot Table feature in Celonis, for more information kindly find the following link
Nope. Thats not what I am looking for., but thank you.
+26Hi @ömer.petek,
You can use the window functions LEAD/LAG (Window (celonis.com)), to get data from a previous/following table entry at the same row. We used this to see behavior of an follow-up case with the same attributes.
Not sure if it solves your use case (do you only want to display rows with 'X', and what if multiple X's exists?), but I think it is the closest you can get ;)
Kind regards,
Jan-peter
Hi @ömer.petek,
You can use the window functions LEAD/LAG (Window (celonis.com)), to get data from a previous/following table entry at the same row. We used this to see behavior of an follow-up case with the same attributes.
Not sure if it solves your use case (do you only want to display rows with 'X', and what if multiple X's exists?), but I think it is the closest you can get ;)
Kind regards,
Jan-peter
Yes it is the closest one thank you. I want to match the cases which has same attributes but I think I need a new data model :(
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
