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!
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.
User | Count |
---|---|
35 | |
31 | |
30 | |
18 | |
17 |