Calculated field help!

I am still a bit confused on the need of the switch condition and the requirement. Can you share a sample data and visual you are looking at in the Arena?

Sharing below what I understood. Switch case will be compiled case by case, so based on your formula, none of the CL_RN is counted under B since the previous case is satisfied all gets encoded as A.

Is this what you want to compute?
image

If yes, how you want to represent all three categories together in a visual, since this recounts the customers and the numbers won’t match with total.

However if your computation is like :
image

You can modify the switch case to yield this.
image

1 Like