Hi @Thimo and thank you for this amazing plugin.
I’m using it for accounting purposes and i’m currently facing a problem trying to display the running balance of an account through an area graph :
I’m using a Repeating Group to calculate in a dynamic way the running balance :
This is how the balance calculation is done :
It’s the sum of each row from the 1st one to the current one, sorted by date.
Now this is working great in a repeating group.
But when i’m trying to display the Balance column on a area graph, i cant find a way to set the correct Series Data’s list of numbers, as this list is not stored in the database. It is not stored and can’t be done as all the values of the list are linked together. Adding, removing or editing a value would have an impact on all the following values as it is by nature a running balance.
This is quite frustrating as the right list of values is printed in the repeating group…
If you have an idea on how to solve this, it would help a lot all financial users as running balance are almost everywhere.
Thank you so much
Romain