(Daniele, is there a nicer way than splitcomp(account, ":", 1)?
Getting a particular subaccount seems pretty common. Also, I
couldn't figure out a way to extract 2 subaccounts - Expenses:Foo:Bar
should yield Expenses:Foo and Expenses:Foo should also yield
Expenses:Foo; is that possible?)
I just noticed one problems with the use of PARENT(). This assumes
that all of your accounts have the same depth.
It might be better to use something like splitcomp(account, ":", 1).
This will give "Foo" for both Expenses:Foo:Bar and Expenses:Foo
Whereas PARENT(account) would give Expenses:Foo
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
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
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
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
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)
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:Test6 USD
Expenses:Test:Foo 2 USD
Expenses:Test:Foo