Expenditure History Report with graph

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

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 766 times
guanlisheng
MMEX Developer
Posts: 375
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.
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: 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: 375
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
Lisheng Guan,
Developer of MoneyManagerEX (http://moneymanagerex.org)
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: 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 668 times
Renato Forum Administrator
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: 655
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

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.
Renato Forum Administrator
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: 655
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Expenditure History Report with graph

Post by Renato »

YES, from Kategorie 12 Monatex.grm
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: 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 715 times
Post Reply