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/40ffcaa8-f4e0-41b3-8399-b19a13cb816bn%40googlegroups.com.
