Pie chart showing percentage of total values

I have a table with car purchase history - a buyer can purchase only 1 of 4 cars, a Tesla, Toyota, Honda or Ford

ID Buyer Car
1 Tom Tesla
2 Peter Honda
3 Adam Tesla
4 John Toyota
5 Mark Tesla
6 Jne Honda

I want a pie chart to show what’s the percentage breakdown b/w sales

I have implemented the car column as enums and Appsheet says it cant chart enums

Is there a way around this? Do I trigger a calculation on every add/update/delete which will update another table? OR is there a way of doing this

Should be easy. Aggregate piechart, group aggregate: count, chart columns: [car] , label type: percent.

Appsheet says it cant chart enums

Where exactly does it say this?

1 Like

thank you!

1 Like