Is there a way to turn this into a quarterly query? Nick
On Monday, January 30, 2017 at 10:43:22 AM UTC-8, Alex Johnstone wrote: > > I suggest creating one or a series of queries to get what you need - then > probably some spreadsheeting if you need to do anything advanced. > > I like keeping a summary table of monthly income and expenses, but which > also includes my mortgage payments, and for that I use this query (saved in > fava): > > > SELECT year, month, root(account, 2) as Account, sum(number) as Total, > currency > WHERE > account ~ 'Expenses' OR > account ~ 'Liabilities:Mortgage' OR > account ~ 'Income' > GROUP BY year, month, Account, currency > ORDER BY year, month, currency, Account > FLATTEN > > The root(account, 2) keeps it at a high level, like Expenses:Car. You can > simplify it further with just root 1 and no month. Then you get your year's > summary. I just press the download as, and then paste it into my > spreadsheet. > > As I'm writing this, I realise that my query is old (from when I first > started playing with it) and you could simplify it with: > > account ~ 'Expenses|Liabilities:Mortgage|Income' > > So, just add or subtract > AND NOT account ~ 'Assets:Not:This:One' > > to your report and get the data that way. > > > -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/a830f428-b408-4b46-881a-c00895938633%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
