Altynbek, thanks for sharing example of usage of jupyter with beancount!
It really helps! On Sunday, January 3, 2021 at 8:51:08 AM UTC+1 [email protected] wrote: > I had to come up with a workaround for interval summaries: > > https://www.isabekov.pro/multiperiod-hledger-style-reports-in-beancount-pivoting-a-table/ > > Having "PIVOT BY period" feature in BQL would faciliate multiperiod report > generation. > > On Friday, 4 December 2020 at 03:35:19 UTC+1 [email protected] wrote: > >> Good to know, thank you for the clarification. >> >> On Wednesday, December 2, 2020 at 4:17:03 PM UTC-5 [email protected] wrote: >> >>> Apologies for this, the PIVOT BY clause implementation was never >>> completed. >>> I've adjusted the documentation. >>> >>> >>> On Tue, Dec 1, 2020 at 8:17 AM [email protected] <[email protected]> >>> wrote: >>> >>>> >>>> I am using Beancount 2.3.1, and am getting the message that the PIVOT >>>> BY clause is not supported yet. Is this something only available in v3+? >>>> It >>>> does still appear to by in the documentation: >>>> https://beancount.github.io/docs/beancount_query_language.html#pivot-by >>>> >>>> The query I am trying to run, it appears PIVOT BY only accepts column >>>> name as syntax and not position: >>>> >>>> >>>> >>>> SELECT >>>> account, >>>> ymonth(date) AS yearmonth, >>>> SUM(COST(position)) AS balance >>>> WHERE >>>> account ~ 'Expenses' AND >>>> NOT account ~ 'Business' AND >>>> currency = 'USD' AND >>>> date_diff(today(), date) < 120 >>>> GROUP BY 1,2 >>>> PIVOT BY account, yearmonth; >>>> >>>> -- >>>> 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 view this discussion on the web visit >>>> https://groups.google.com/d/msgid/beancount/b35d0cc0-9fff-45e5-a9bc-3e1e9cf74838n%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/beancount/b35d0cc0-9fff-45e5-a9bc-3e1e9cf74838n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/beancount/f41d648a-62b6-4095-b458-577cfd8be624n%40googlegroups.com.
