Favorite account balance history

Build and share your cool customized reports built w/ one sql, Chart.js and Lua

Moderator: Renato

sterling
Super MMEX 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 869 times
guanlisheng
MMEX Developer
Posts: 375
Joined: Wed Dec 21, 2011 5:58 am
Are you a spam bot?: No
Location: China
Contact:

Re: Favorite account balance history

Post by guanlisheng »

Great report and would you please post it to Github ?
Lisheng Guan,
Developer of MoneyManagerEX (http://moneymanagerex.org)
sterling
Super MMEX 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.
guanlisheng
MMEX Developer
Posts: 375
Joined: Wed Dec 21, 2011 5:58 am
Are you a spam bot?: No
Location: China
Contact:

Re: Favorite account balance history

Post by guanlisheng »

Thanks in advance
Lisheng Guan,
Developer of MoneyManagerEX (http://moneymanagerex.org)
sterling
Super MMEX 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 :).
Nikolay
MMEX 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 593 times
User avatar
Renato
MVP MMEX User
Posts: 655
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
Nikolay
MMEX 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.
Nikolay
MMEX 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 644 times
User avatar
Renato
MVP MMEX User
Posts: 655
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
Post Reply