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 MMEX 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
MMEX 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
MMEX 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
Attachments
DiningOutExpenses.grm
(3.08 KiB) Downloaded 736 times
tony@floorex.com.au
New MMEX 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?
Attachments
Food (General) Trend.grm
(3.2 KiB) Downloaded 686 times
Nikolay
MMEX 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
Attachments
DiningOutExpenses_v0.grm
(2.82 KiB) Downloaded 732 times
Post Reply