Favorite account balance history

GRM Reports Build and share your cool customized reports built w/ SQL, JS and Lua

Moderator: Renato

sterling
Super User
Posts: 72
Joined: Thu Dec 11, 2014 8:40 am
Are you a spam bot?: No

Favorite account balance history

Post by sterling »

Hi,

This is a graph that i used a lot from GnuCash.  It currently shows 8 favourite account balances over the past year as a stacked bar graph.  I've ended up transposing the table from SQL in JavaScript here so the charting script can display it how i wanted.  I'm going to add a line graph over the top to show total savings per month.

We use this to track savings.
Attachments
Savings Progress v3.grm
(2.46 KiB) Downloaded 1729 times
Top
guangong
Developer
Posts: 658
Joined: Wed Dec 21, 2011 5:58 am
Are you a spam bot?: No

Re: Favorite account balance history

Post by guangong »

Great report and would you please post it to Github ?
Lisheng Guan,
Developer of MoneyManagerEX (http://moneymanagerex.org)
Top
sterling
Super User
Posts: 72
Joined: Thu Dec 11, 2014 8:40 am
Are you a spam bot?: No

Re: Favorite account balance history

Post by sterling »

Sure, I will do.
Top
guangong
Developer
Posts: 658
Joined: Wed Dec 21, 2011 5:58 am
Are you a spam bot?: No

Re: Favorite account balance history

Post by guangong »

Thanks in advance
Lisheng Guan,
Developer of MoneyManagerEX (http://moneymanagerex.org)
Top
sterling
Super User
Posts: 72
Joined: Thu Dec 11, 2014 8:40 am
Are you a spam bot?: No

Re: Favorite account balance history

Post by sterling »

I've just submitted some improvements to this report.  The legend has been merged into the table and there is now a totals row in the table as well.  Tidier and prettier :).
Top
Nikolay
Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Favorite account balance history

Post by Nikolay »

Several fixes provided
1. Multicurrency support
2. 12 months instead 13 used
3. Human readable labels for months
4. Investment accounts excluded
Attachments
Savings Progress v4.grm
(2.76 KiB) Downloaded 1337 times
Top
User avatar
Renato
MVP User
Posts: 881
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Favorite account balance history

Post by Renato »

Hello Nikolay
Nice, but again I miss the total of the month
Renato Forum Administrator (I'm not a developer)
Top
Nikolay
Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Favorite account balance history

Post by Nikolay »

I left the field to the author for creativity.
Top
Nikolay
Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Favorite account balance history

Post by Nikolay »

New version with js fixes and totals
Attachments
Savings Progress v5.grm
(2.93 KiB) Downloaded 1470 times
Top
User avatar
Renato
MVP User
Posts: 881
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Favorite account balance history

Post by Renato »

Hello Nikolay
The results from the current month are wrong.
Renato Forum Administrator (I'm not a developer)
Top

Return to “General Reports Manager”

Who is online

Users browsing this forum: Claude [Bot] and 0 guests