I’ve installed the Chart Kit and now I am trying to make a simple cost x category Pie Chart.
These are my Collections:
User > Projetos > Lancamentos > Categorias.
Each Lancamento have a vl_lancamento ( money/amount ).
I want to show display a Pie Chart showing sum(lancamento.vl_lancamento) grouped by Category, so I users will know where they are spending most of their Money.
I’ve tried many combinations but so far it didn’t work well.
Good to know I can do some math in the Value field… I thought I could only set the attributes.
Yet, I tried your suggestion, but it didn´t work well… Also, note that I am grouping only the Lancamentos under the one Project I am under, not ALL lancamentos at all. I think what I am missing is how my Project Lancamentos can be grouped by Categories.
I just checked the 2nd Project Pie Chart and it shows 50/50. But this is not right… it is saying half is “Acabamento” and the other half is “Ferragens”. It is clearly counting the categories rather the Amount.
Hello @dilon_perera This worked like a charm man ! Thank you very much.
I also saw what you´ve done with the Add Filter on the Slice Value… I think this made all the difference from when I previously tried the Chart on the Categories as well… It was bringing all Projects categories. The fileter narrowed it down to the current project only… Got it.