Number of Cases in which Activity occured more than once - Dimension as Variable


#1

Hey community,

I would like to build an analysis showing the (distinct) list of activities on the left as the dimension and as the KPI the number of cases, in which the activity on the left occured more than once.
So that could be part of a rework analysis.
I could not find that in the content store, though I think it’s interesting.

Any ideas or materials on this?


#2

Hey Marcel,

This one should work:

COUNT(DISTINCT CASE WHEN ACTIVATION_COUNT("_CEL_P2P_ACTIVITIES"."ACTIVITY_EN") > 1 THEN "_CEL_P2P_ACTIVITIES"."_CASE_KEY" ELSE NULL END)