Enum List in Histogram with individual items

[LooToS]

Hi everyone, 

currently I am trying to build a dashboard for my data that involves several Enum Lists. This is an example but let's say I have the column "Fruit" that is an Enum List. 

The entries might are:

1. Banana, Mango

2. Banana

3. Strawberry, Mango

4. Mango

Now I want to show the results in a Histogram, but it always uses the whole object to put into the diagram. The expected result would be to have the individual counts per item: Banana 2x, Mango 3x, Strawberry 1x.

Is there an easy way to do it? I tried using SPLIT(), or a lookup table, but that did not work.

Thanks for your help!

[Suvrutt_Gurjar]

Yes, I believe there is currently no easy way to plot histogram on an enumlist in AppSheet. It could be possibly achieved in a convoluted way. It would need some significant additional configuration through actions etc. or aggregation through multirow expressions that could be resource intensive.