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
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.