I have a table BALANCE which has the columns:
- [month] - of type date which is the 1st day of each month
- [budget] - of type decimal, which has a fixed amount which is the budget for that month
- [spent] - virtual column which is the sum of all expenses that happened on that month
- [remains] - virtual column which is the result of [budget] - [spent]
Also, I’ve created a slice CURRENT_MONTH_BALANCE which has only 1 row which is the one that corresponds to the current month. So, my slice would look like this:
My intention is to have a Donut or Pie chart that will display the “spent” vs the “remains” amounts.
So, in this example, the Donut or Pie chart will show a 1/4 of the pie in one color (spent) and 3/4 in another color (remains).
But… I’m not able to make this work in AppSheet, since I just get 1 color donut/pie that sums both “spent” and “remains” value (so, just one circle telling 2300 )
Ive tried both, the classic and the newer chart version, but I don’t seem to get it working…
What am I missing?