Hi Team,
We are trying to identify and associate flag to a particular activity based on whether there were some other set of activities post it or not till the next instance of the activity. So for example we want to associate a flag to Activity A if in a case journey activity B, C, D or E are occuring any time between the next occurence of Activity A within the case.
We intend to track this for each instance of activity A taking place within a case and associate a flag whether the activities B,C, D or E took place or not in an OLAP table.
We are looking for any way in which we can set the scope from the instance of activity A taking place till its next instance and check within this scope whether the other activities took place.
Thanks in Advance.
Soham Potdar
Page 1 / 1
Hi @Soham_Potdar,
thanks for reaching out!
In the following, I will explain you one way to solve this problem. We will create the following OLAP Table:
image785257 6.32 KB
- _CASE_KEY: Add the case key as a dimension:
- condition: As a first KPI, we want to add the flagging or not flagging condition. This is the hard part of the problem. In the case below, I have chosen the activity Change Quantity to be your Activity A. You can simply substitute the PQL code with your desired Activity A.
- Activity: Next, we want to add a KPI simply in form of an activity. This is the third column in our OLAP table:
- lagged activity: Last, we add the respective successor activity to every activity displayed in the third column. Simply add a KPI stating:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.