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
