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/CAK21%2BhPdh%2Bb7%3DOTowvUOr2jHMcop%3DDinwX31pmcq1Vvk2K%3DrOw%40mail.gmail.com.
