I know. Send me a patch?
On Sun, Jan 3, 2021 at 2:51 AM Altynbek Isabekov < [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/c5e1e537-710b-4bd7-9e21-e67369b09e83n%40googlegroups.com > <https://groups.google.com/d/msgid/beancount/c5e1e537-710b-4bd7-9e21-e67369b09e83n%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/CAK21%2BhMo9aZ0MOs%3DRT3UbXQES9gdqFySvdkbr%3DmD81kJpv3WsQ%40mail.gmail.com.
