MMEX Desktop v1.3.4.rc.3 is ready https://github.com/moneymanagerex/money ... 1.3.4-rc.3

Favorite account balance history

Build and share your cool customized reports built w/ one sql, Chart.js and Lua (https://github.com/moneymanagerex/general-reports)
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 583 times

guanlisheng
MMEX Developer
Posts: 195
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 ?

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: 195
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

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: 1176
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 315 times

User avatar
Renato
Super MMEX User
Posts: 91
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No

Re: Favorite account balance history

Post by Renato »

Hello Nikolay
Nice, but again I miss the total of the month
regards Renato

use MMEX since 2009

Nikolay
MMEX Developer
Posts: 1176
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: 1176
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 361 times

User avatar
Renato
Super MMEX User
Posts: 91
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No

Re: Favorite account balance history

Post by Renato »

Hello Nikolay
The results from the current month are wrong.
regards Renato

use MMEX since 2009

Post Reply