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.
Try using the Pivot Table feature in Celonis, for more information kindly find the following link
https://docs.celonis.com/en/pivot-table.html
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.
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
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.
