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!