Expenditure History Report with graph

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

Moderator: Renato

User avatar
Renato
MVP User
Posts: 674
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 »

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:

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
Nikolay
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 »

Updated.
Added:
- Sorting
- German translation
- nowrap for amounts
- formating
You do not have the required permissions to view the files attached to this post.
User avatar
Renato
MVP User
Posts: 674
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 »

Hi Nikolay

Thank you very much, wonderful evaluation, it shows me where I have spent all my money in the last 12 months.
Image
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
Nikolay
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 »

Just modify this report to have grouped by year stats.
it will categs stats for last 12 years.
sterling
Super 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 »

Cool, would you like to update it on github?
Nikolay
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 »

sterling wrote:Cool, would you like to update it on github?
Yes, just for one big with graph labels (should be full name not category name).
Mukund
New User
Posts: 12
Joined: Thu Oct 30, 2014 4:51 pm
Are you a spam bot?: No

Re: Expenditure History Report with graph

Post by Mukund »

Nikolay wrote:Updated.
Added:
- Sorting
- German translation
- nowrap for amounts
- formating
Sir, the graph is not display.
Nikolay
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 »

Iexplore version is  >= 9 ?
Nikolay
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 »

Updated.

I think will be better to change this report for show only withravals. It will be "Where the money goes".
You do not have the required permissions to view the files attached to this post.
sterling
Super 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 »

Nikolay wrote:Updated.

I think will be better to change this report for show only withravals. It will be "Where the money goes".
Like my original?  That's why I didn't understand the change request.  Probably a language thing.  Expenditure means withdrawal.
Nikolay
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 »

My report used your graph algorytm but other Sql.
My report shows all Categs.
sterling
Super 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 »

Nikolay wrote:My report used your graph algorytm but other Sql.
My report shows all Categs.
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
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 »

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" .......
You do not have the required permissions to view the files attached to this post.
Mukund
New User
Posts: 12
Joined: Thu Oct 30, 2014 4:51 pm
Are you a spam bot?: No

Re: Expenditure History Report with graph

Post by Mukund »

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" .......
Sir, Graph is not visible? Can you help me?
Nikolay
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 »

How many rows in table?
sterling
Super 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 »

Nikolay wrote:How many rows in table?
I dont get a graph with limit 10 in the query.  I'll have a chance to debug at the weekend.
Nikolay
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 »

Seems ChartNew.js outdated

To start graph working delete 

Code: Select all

                responsive : true,
in template (line 227).
Mukund
New User
Posts: 12
Joined: Thu Oct 30, 2014 4:51 pm
Are you a spam bot?: No

Re: Expenditure History Report with graph

Post by Mukund »

Nikolay wrote:How many rows in table?
Sir i have 101 rows.
aramacciotti
Senior User
Posts: 25
Joined: Mon Jun 02, 2014 7:17 am
Are you a spam bot?: No

Re: Expenditure History Report with graph

Post by aramacciotti »

I also don't get the graphs for "where the money goes" when the analysis period is long enough to generate a many different rows (not clear which is the limit, but it works when rows are 19)
Post Reply