Displaying Data

#1

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.

#2

I’ll open up a discussion in regards to adding the features you suggested.

If you can’t figure it out by only using charts, perhaps you could make an intermediate module into which you would insert workflow-generated records which you would then show on charts.

I’m not entirely sure I understand what you’re trying to do so I can’t help more than that.