https://bitbucket.org/blais/beancount/commits/cef34085473e46256bad28c966a51ae3a488b7ae hg fetch, I've added a QUARTER() function.
SELECT QUARTER(date), ... On Fri, Apr 27, 2018 at 10:22 PM, <[email protected]> wrote: > 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 > <https://groups.google.com/d/msgid/beancount/a830f428-b408-4b46-881a-c00895938633%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- 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/CAK21%2BhPt5LexO0JLcrsREYuZrh3rZD4RN%2B7QO9iMwD8AzK6XnQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
