use group by in pie chart

[janus2021]

Hi.

New question.

in a Pie chart i have as a dimension I have a field: PLANTS that show: sunflower, tulip, pine, oak etc and a measure showing sum (PLANTS ). Then the diagram shows all the different plants in percent. Is it possible to group / show ex: sunflower and tulip as one value ex flower and pine, oak as wood?

and also keep the summary correct.

[GaryGiles · Accepted solution]

Try using the Pick and Match combination:

Pick(Match(PLANTS,'sunflower','tulip','pine','oak'),'flower','flower','wood','wood')

[janus2021]

Hi.

It works but i cant get i to work with sum(PLANTS), any tip how to make it work?

[tresesco]

Use the above expression as calculated dimension (expression) in your chart, and then your expression as is, i.e - sum(PLANTS)

[janus2021]

Thanks.
Sometimes I'm blind to the most obvious things 🙂