How to Count the same record again with Multi-Selection Attributes

PJG

I have a multi-selection attribute with 19 selection options within it.

I am trying to group these 19 selection options into 5 slices on a pie chart with this code:

case

when Impacted Business Division_p LIKE '%Biologics%' then 'Biologics'

when Impacted Business Division_p LIKE '%CGT%' then 'CGT'

when Impacted Business Division_p LIKE 'China' then 'China'

when Impacted Business Division_p LIKE '%CHI - %' then 'CHI'

when Impacted Business Division_p LIKE '%Small Molecules%' then 'Small Molecules'

else 'Not Defined'

end

The result for Biologics is correct. Then it seems that it won't count CGT if it was previously counted for Biologics. However, if the selection options are Biologics - DPS|CGT & Bioscience, I would want it counted for both Biologics and CGT.

Then it won't count China if it was already counted for Biologics or CGT, and so on.

How can make it count every instance, even if it's been counted for one of the other categories already? Thanks!

ColemenWilson

Single-selection attributes are my preference for sure! But when I've had to deal with multi-select I use the split column tile and pivot/unpivot to get one row per selection and then use the data to build visualizations. Did you end up getting what you needed here?