Expenditure History Report with graph

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

Expenditure History Report with graph

Post by sterling »

Hi,

New general report time again :).

This one collates your top expenditures for the past 8 months and shows them graphically per month.

Let me know if you see ways to optimise.
Attachments
Expenditure History.grm
(2.35 KiB) Downloaded 512 times

guanlisheng
MMEX Developer
Posts: 205
Joined: Wed Dec 21, 2011 5:58 am
Are you a spam bot?: No
Location: China
Contact:

Re: Expenditure History Report with graph

Post by guanlisheng »

Hi, one screen shot plus a link to Github are more preferred.

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

Re: Expenditure History Report with graph

Post by sterling »

guanlisheng wrote:Hi, one screen shot plus a link to Github are more preferred.
Is was thinking about screenshots too.  Is there a sample accounts file I can use for screenshots?  So I don't post my accounts.

guanlisheng
MMEX Developer
Posts: 205
Joined: Wed Dec 21, 2011 5:58 am
Are you a spam bot?: No
Location: China
Contact:

Re: Expenditure History Report with graph

Post by guanlisheng »

I will fake several ones and post them on Github in near future for both feature testing and performance testing

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

Re: Expenditure History Report with graph

Post by Renato »

Have extended to 12 months and translated into German.
However, I have not managed to change the code so that both revenue as expenditures are expected. Reason: also credits should be offset.

can someone help me.
Attachments
Kategorie 12 Monatex.grm
(2.55 KiB) Downloaded 404 times
regards Renato

use MMEX since 2009

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

Re: Expenditure History Report with graph

Post by sterling »

Renato wrote:Have extended to 12 months and translated into German.
However, I have not managed to change the code so that both revenue as expenditures are expected. Reason: also credits should be offset.

can someone help me.
Hi,

I'm glad you've found my report useful :).  I've just added a new version of the report to https://github.com/moneymanagerex/general-reports, which merges the legend into the table and puts the months on the table instead of "1 month ago" etc.

I'm not sure what you mean by "both revenue as expenditures are expected. Reason: also credits should be offset" though.

I'm happy to add the feature if i understand it.

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

Re: Expenditure History Report with graph

Post by Renato »

Please analyze my code.
I need not only the payments but also the credits.
Example: I have been paying provisional tax, now they are definitely and I get back my money.
regards Renato

use MMEX since 2009

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

Re: Expenditure History Report with graph

Post by sterling »

Which bit of code? the sql?

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

Re: Expenditure History Report with graph

Post by Renato »

YES, from Kategorie 12 Monatex.grm
regards Renato

use MMEX since 2009

Nikolay
MMEX Developer
Posts: 1298
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Expenditure History Report with graph

Post by Nikolay »

Hi Renato,

Please try this one

Why this report is better:
- It's count split transactions;
- it count withdrawal and deposits;
- It may be translated to any language;
Attachments
Categs Last 12 months_v5.grm
(3.59 KiB) Downloaded 453 times

Post Reply