Enum list in Histogram

AppSheet AppSheet Q&A
1

Hello bro,i have difficulties using enum list … the case is i select so many list each selection , then i want to show in histogram ( percent ) , how many list i have selected , but it didn’t work … can you tell me the solution ? Example :

  1. i select: banana
  2. i select : banana, manggo, grape
  3. i select : manggo, grape

I want to show in histogram cart ( percent) how many grape i have selected compare to the total item , but it didn’t work in enum list. Please help me

2

Sounds like you need an additional column to calculate the percentage value that you’re wanting to chart.

COUNT( [EnumList] ) / #total-items#
2 Likes