Help with a simple piechart with formulas

[Ceravieja]

Hello everyone,
I'm new to AppSheet and I'm making a simple app for a friend who has a sewing business.
The App takes  the income and expenses of her shop and I would like to add a simple piechart where it shows the accumulated income and expenses, the amounts are obtained by a formula.
However, displaying them in the piechart doesn't work like I want, I've tried various tricks of this page, but with no result.
Can someone give me a hand?, thanks.

Here are some screenshots:

[gregdiana1 · Accepted solution]

I used this table

And then used the AGGREGATE PIE CHART (NOT PIE CHART) as follows

and got

The problem now is you only see the count and not Ingresos and Gastos.

To see the variables rather have the column Status1 with the text either Ingresos and Gracos and do not do any sumif() as shown below

Now if you use column Status1 instead of Status you get

If you choose values instead of % you get

So the group aggregate does the sumif() as COUNT for you and thus you may use the native data from the columns and do not require any formulas as you have done.

Cheers

Greg Diana

[gregdiana1 · Accepted solution]

I used this table

And then used the AGGREGATE PIE CHART (NOT PIE CHART) as follows

and got

The problem now is you only see the count and not Ingresos and Gastos.

To see the variables rather have the column Status1 with the text either Ingresos and Gracos and do not do any sumif() as shown below

Now if you use column Status1 instead of Status you get

If you choose values instead of % you get

So the group aggregate does the sumif() as COUNT for you and thus you may use the native data from the columns and do not require any formulas as you have done.

Cheers

Greg Diana

[Ceravieja]

Hi Greg Diana, thanks for the help, it works!
Instead of using the "Situacion Economica" table I have changed the data to the original place "Libro Contable" and make these changes:





Finally a simple question: is there any way to show the euro symbol in the piechart?

[gregdiana1 · Accepted solution]

For currency see

https://support.google.com/appsheet/answer/10107385?hl=en#:~:text=Select%20Data%20%3E%20Columns%20an....

Essentially define column CANTIDAD as TYPE PRICE

[Ceravieja]

Hi again, my friend ask me for an upgrade to the piechart:

She wants the INGRESOS and GASTOS to be shown, but depending on the month that is chosen from the dropdown list, something like this:

Is there any way to show this in the piechart?, thanks a lot.

Paco.