Related threads: https://groups.google.com/forum/#!msg/beancount/S3lrphO-e2c/DIdxaUKBDgUJ https://groups.google.com/forum/#!searchin/beancount/pivot$20select|sort:date/beancount/326EDC8cm7I/XNrBhNBgCgAJ https://groups.google.com/forum/#!searchin/beancount/pivot$20select|sort:date/beancount/otu6I7NX5YQ/VLP7WbamEwAJ
Ticket: https://bitbucket.org/blais/beancount/issues/61/implement-pivot-table-tool-make-sure-it Recently I hashed out a Python script to prototype this to try to feel whether the PIVOT BY idea would be sufficient. Feel free to copy and modify to your own taste: https://bitbucket.org/blais/beancount/src/tip/experiments/budget/monthly_expenses.py I hope this helps, On Sat, Oct 20, 2018 at 9:16 PM <[email protected]> wrote: > Hi I recently converted 10+ years of quicken data into beancount and I am > not looking back! > > One help needed is in bean-query... what is the best query to return > columns as time periods? For example, months or years as columns and an > account list or transaction list as rows? > > I can get this kind of report using Fava but I can't design a query to > return it. I have read that PIVOT BY might achieve this but it isn't > available yet. > > Thanks alot for a great project! > > -- > 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/30be3907-c5f3-4332-af0c-1d84c86bd3fd%40googlegroups.com > . > 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%2BhMouXAujLPHrDBBg7pW4fKCR5HBDCdG15UYDqVnXe4ahA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
