Rework Analysis by case keys in column chart

Hello Team,

We are trying to calculate the rework cases for activity in different approach i.e in column chart where we need if case key has executed more than once , twice or thrice for particular activity then each cases should be unique in each column logic

for eg:-
More than once case keys executed should not repeat in more than twice column and same with thrice column.

Below is the logic we are looking for to calculate the same but not able to get unique records .

greater than 1 =Cases should not repeat in >2 and >3 column
greater than 2=Cases should not repeat in >1 and >3 column
greater than 3=Cases should not repeat in >2, >1 column

Kindly let me know how best we can create the logic , awaiting for your response.

Hi Kaveri,

Did you experiment with the histogram component?
You dimension should return the # of repetitions per case, the histogram plot will then plot the frequency of each of the numbers.

Thanks Joosbuijs,

Its not working for me , please find the below formula being used for the same.

Kindly confirm if the formula looks fine.

CASE WHEN ACTIVATION_COUNT("_CEL_FA_ACTIVITIES".“ACTIVITY_EN”) > 1 AND ACTIVATION_COUNT("_CEL_FA_ACTIVITIES".“ACTIVITY_EN”) <= 2 THEN ‘>1’
WHEN ACTIVATION_COUNT("_CEL_FA_ACTIVITIES".“ACTIVITY_EN”) > 2 AND ACTIVATION_COUNT("_CEL_FA_ACTIVITIES".“ACTIVITY_EN”) <= 3 THEN ‘>2’
WHEN ACTIVATION_COUNT("_CEL_FA_ACTIVITIES".“ACTIVITY_EN”) > 3 THEN ‘>3’
ELSE ‘1’ END