hey! I am trying to create an ismart chart but the truth is that I am not achieving my goal, I have read the documentation on the subject but I do not think it is enough.
In my project I have a schema called Transactions which has the following form:
As you can see, it has a related field which contains charity_id and amount to pay to that charity.
What I would like to achieve is to create a chart where you can see the charity_id and the sum of all the amounts corresponding to different transactions but to the same charity id.
For example if I have transcction1->charity1->amount=30 and transcction2->charity1->amount=70, I could see in the dashboard a graph that would be:
| charityid | amount |
I suppose that creating a chart where the datasource is a query could be achieved but the issue is that I do not see this option when I want to create charts, only simple and api appears.
I appreciate your help,