I tend to use beancount and beanquery to extract interesting data and to do further processing in pandas in Jupyter Notebook, where data processing and visualization tools are very developed.
https://www.isabekov.pro/multiperiod-hledger-style-reports-in-beancount-pivoting-a-table/ I think what you are asking for is effectively pivot table subtotals. This can be done both in pandas <https://www.statology.org/pandas-pivot-table-subtotals/> On Thursday, December 21, 2023 at 11:51:57 AM UTC+1 t...@cyrius.com wrote: > bean-report is deprecated. > > You can do the following in bean-query: > > SELECT PARENT(account), position, balance WHERE account ~ 'Expenses:Test:' > > you can also use PARENT(PARENT(account)) > > This is for register report. For balance report, something like that: > > SELECT PARENT(account), SUM(position) WHERE account ~ 'Expenses:Test:' > GROUP BY PARENT(account) > > (There might be more elegant ways of doing this, but the queries above > work for me.) > > Martin > > > * Dan Andersson <danande...@gmail.com> [2023-12-21 02:38]: > > Hi, > > > > Example bean-report output: > > > > Expenses:Test:Foo 2 USD > > > > Expenses:Test:Foo 4 USD > > > > How can I automatically show summations for all super-accounts? For > > example > > > > Expenses 6 USD > > > > Expenses:Test 6 USD > > > > Expenses:Test:Foo 2 USD > > Expenses:Test:Foo 4 USD > > Thanks, > > Dan > > > > -- > > 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 [1]beancount+...@googlegroups.com. > > To view this discussion on the web visit > > [2]https://groups.google.com/d/msgid/beancount/ff1ad476-8e0c-4cd2-ac1c- > > 4eec19af8554n%40googlegroups.com. > > > > References > > > > 1. mailto:beancount+...@googlegroups.com > > 2. > https://groups.google.com/d/msgid/beancount/ff1ad476-8e0c-4cd2...@googlegroups.com?utm_medium=email&utm_source=footer > > <https://groups.google.com/d/msgid/beancount/ff1ad476-8e0c-4cd2-ac1c-4eec19af85...@googlegroups.com?utm_medium=email&utm_source=footer> > > -- > Martin Michlmayr > https://www.cyrius.com/ > > -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/7d0be07c-5236-4395-b527-ba367209ec2bn%40googlegroups.com.
