Fava is a great tool, but so far I haven't found what extra would I get to what I have already in my setup:
I am using VScode to enter beancount ledger as well as to run Jupyter notebook with all the queries and visualizations in it. As I said, data processing and visualization is so developed in pandas + matplotlib + Jupyter invironment, that it is hard to beat it. On Saturday, December 23, 2023 at 6:48:00 AM UTC+1 Red S wrote: Nice. What would be terrific is if this workflow (query -> pandas -> Jupyter + Visualization) got integrated seamlessly into Fava. On Thursday, December 21, 2023 at 4:01:52 AM UTC-8 char...@gmail.com wrote: 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 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/709a4faf-a1e6-4fe2-b609-f29e01bf33a9n%40googlegroups.com.