I am struggling to find a way to display Running End of Month Totals.
Essentially what I am trying to create is similar to a banking feed.
Where I may enter Deposits, Withdrawals, Growth/Interest.
I am then looking to display end of month totals on a Graph however I cannot find a way to do this
The graphing tool allows us to group by day/week/month/year… we can also chose the Max/Min/Average values…
However, there doesnt seem to be a way to set the chart so that ip pulls the value for the latest date each month.
Another Graphing feature which I cannot find is to display via bar graph a percentage change per month
If there was an option to run more advanced SQL Queries I feel that would massively help.