Expenditure History Report with graph
Moderator: Renato
Expenditure History Report with graph
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.
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 773 times
-
- Developer
- Posts: 381
- Joined: Wed Dec 21, 2011 5:58 am
- Are you a spam bot?: No
- Location: China
- Contact:
Re: Expenditure History Report with graph
Hi, one screen shot plus a link to Github are more preferred.
Lisheng Guan,
Developer of MoneyManagerEX (http://moneymanagerex.org)
Developer of MoneyManagerEX (http://moneymanagerex.org)
Re: Expenditure History Report with graph
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 wrote:Hi, one screen shot plus a link to Github are more preferred.
-
- Developer
- Posts: 381
- Joined: Wed Dec 21, 2011 5:58 am
- Are you a spam bot?: No
- Location: China
- Contact:
Re: Expenditure History Report with graph
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)
Developer of MoneyManagerEX (http://moneymanagerex.org)
- Renato
- MVP User
- Posts: 673
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Expenditure History Report with graph
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.
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 673 times
Renato Forum Administrator
Re: Expenditure History Report with graph
Hi,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.
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.
- Renato
- MVP User
- Posts: 673
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Expenditure History Report with graph
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.
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
Re: Expenditure History Report with graph
Which bit of code? the sql?
- Renato
- MVP User
- Posts: 673
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Expenditure History Report with graph
YES, from Kategorie 12 Monatex.grm
Renato Forum Administrator
-
- 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
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;
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 720 times
- Renato
- MVP User
- Posts: 673
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Expenditure History Report with graph
Hi Nikolay
Thank you, Perfect, just what I need, unfortunately, the graphics and the months in the head is not displayed.
Here is the translation in German:
Thank you, Perfect, just what I need, unfortunately, the graphics and the months in the head is not displayed.
Here is the translation in German:
Code: Select all
"german": [{
"_Title":"Übersicht letzte 12 Monate"
, "Category": "Каtegorie", "Overall":"Total"
, "Jan": "Jan", "Feb": "Feb", "Mar":"Мär"
, "Apr": "Аpr", "May": "Маi", "Jun":"Jun"
, "Jul": "Jul", "Aug": "Аug", "Sep":"Sep"
, "Oct": "Оkt", "Nov": "Nov", "Dec":"Dez"
, "Total:":"Total:"
}],
Renato Forum Administrator
-
- 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
Updated.
Added:
- Sorting
- German translation
- nowrap for amounts
- formating
Added:
- Sorting
- German translation
- nowrap for amounts
- formating
- Attachments
-
- Categs Last 12 months_v6.grm
- (4.11 KiB) Downloaded 621 times
- Renato
- MVP User
- Posts: 673
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Expenditure History Report with graph
Hi Nikolay
Thank you very much, wonderful evaluation, it shows me where I have spent all my money in the last 12 months.
By the way: If we could still enter the start date instead of just from today, then you could analyze / compare the last few years.
Thank you very much, wonderful evaluation, it shows me where I have spent all my money in the last 12 months.
By the way: If we could still enter the start date instead of just from today, then you could analyze / compare the last few years.
Renato Forum Administrator
-
- 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
Just modify this report to have grouped by year stats.
it will categs stats for last 12 years.
it will categs stats for last 12 years.
Re: Expenditure History Report with graph
Cool, would you like to update it on github?
-
- 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
Yes, just for one big with graph labels (should be full name not category name).sterling wrote:Cool, would you like to update it on github?
Re: Expenditure History Report with graph
Sir, the graph is not display.Nikolay wrote:Updated.
Added:
- Sorting
- German translation
- nowrap for amounts
- formating
-
- 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
Iexplore version is >= 9 ?
-
- 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
Updated.
I think will be better to change this report for show only withravals. It will be "Where the money goes".
I think will be better to change this report for show only withravals. It will be "Where the money goes".
- Attachments
-
- Categs Last 12 months_v7.grm
- (4.17 KiB) Downloaded 648 times
Re: Expenditure History Report with graph
Like my original? That's why I didn't understand the change request. Probably a language thing. Expenditure means withdrawal.Nikolay wrote:Updated.
I think will be better to change this report for show only withravals. It will be "Where the money goes".
-
- 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
My report used your graph algorytm but other Sql.
My report shows all Categs.
My report shows all Categs.
Re: Expenditure History Report with graph
Yeah, i recognised it. The graph doesn't work for me any more either, not debugged it though. I use chrome for my main browser.Nikolay wrote:My report used your graph algorytm but other Sql.
My report shows all Categs.
-
- 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
Try new release
https://sourceforge.net/projects/moneym ... .2.0-beta/
I've changed my report to have only expenses.
Or may be problem with colors (too few values)
https://sourceforge.net/projects/moneym ... .2.0-beta/
I've changed my report to have only expenses.
Or may be problem with colors (too few values)
Code: Select all
var dataAccountColours = [
"#f79646", "#f5f445", "#7fd13b", "#4bacc6", "#1f497d", "#8064a2" .......
- Attachments
-
- Expenditure_History_last12months_v7.grm
- (4.25 KiB) Downloaded 774 times
Re: Expenditure History Report with graph
Sir, Graph is not visible? Can you help me?Nikolay wrote:Try new release
https://sourceforge.net/projects/moneym ... .2.0-beta/
I've changed my report to have only expenses.
Or may be problem with colors (too few values)Code: Select all
var dataAccountColours = [ "#f79646", "#f5f445", "#7fd13b", "#4bacc6", "#1f497d", "#8064a2" .......
-
- 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
How many rows in table?