Quick Weekly budget on one Category

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

Moderator: Renato

Post Reply
tonyreynolds16
New User
Posts: 1
Joined: Tue Dec 23, 2014 11:45 am
Are you a spam bot?: No

Quick Weekly budget on one Category

Post by tonyreynolds16 »

I'm Trying to get my head around the reporting code language I've done plenty of VBA in Excel but yeah,

What I'm trying to do is have a report that simply shows total spend on all transactions on all accounts from one category 'Food / Drink' in week blocks starting form the current week and only show back12 weeks.

a bar graph at the top for visual would be great too.

Can someone help me get started?

Any help is appreciated
Nikolay
Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Quick Weekly budget on one Category

Post by Nikolay »

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

Re: Quick Weekly budget on one Category

Post by Nikolay »

Try this one
You do not have the required permissions to view the files attached to this post.
tony@floorex.com.au
New User
Posts: 1
Joined: Mon Jun 18, 2012 12:22 pm
Are you a spam bot?: No

Re: Quick Weekly budget on one Category

Post by tony@floorex.com.au »

That's really great.. I've made some changes to the chart as I didn't want the difference and deposits

I guess there is quite a bit of left over code used for these that could be cut out but ive only removed it from the Template not LUA.

What I really want to do is get it to show weeks not months...

Can this be done?
You do not have the required permissions to view the files attached to this post.
Nikolay
Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Quick Weekly budget on one Category

Post by Nikolay »

Quite difficult task.
Somthing like that
You do not have the required permissions to view the files attached to this post.
Post Reply