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/c5e1e537-710b-4bd7-9e21-e67369b09e83n%40googlegroups.com.
