How to check whether after a certain activity , a transaction has occurred or not ?ACTIVITY_EN is the activity field and EVENT_TYPE is the transaction field

Hi Dipro,

Depending on the way you would like to present this, you could for instance create an OLAP Table with the Activities as Dimension and compute a KPI that counts whether the transaction has occured or not. Basically with a Case When statement you could find the answer!

Hope this helps.