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?
thank you!
User | Count |
---|---|
18 | |
15 | |
10 | |
7 | |
4 |