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.
