Time periods in columns in bean-query

[tod...@gmail.com]

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!

[Martin Blais]

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,

--
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 beancount+...@googlegroups.com.
To post to this group, send email to bean...@googlegroups.com.
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.