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: 669
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
Attachments
Categs Last 12 months_v6.grm
(4.11 KiB) Downloaded 614 times
User avatar
Renato
MVP User
Posts: 669
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".
Attachments
Categs Last 12 months_v7.grm
(4.17 KiB) Downloaded 642 times
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" .......
Attachments
Expenditure_History_last12months_v7.grm
(4.25 KiB) Downloaded 772 times
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