PIVOT BY clause not supported yet (2.3.1)?

[cha...@gmail.com]

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;

[Martin Blais]

Apologies for this, the PIVOT BY clause implementation was never completed.

I've adjusted the documentation.

--
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 beancount+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/b35d0cc0-9fff-45e5-a9bc-3e1e9cf74838n%40googlegroups.com.

[cha...@gmail.com]

Good to know, thank you for the clarification.

[Altynbek Isabekov]

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.

[Martin Blais]

I know. Send me a patch?

To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/c5e1e537-710b-4bd7-9e21-e67369b09e83n%40googlegroups.com.

[Chary Chary]

Altynbek,

thanks for sharing example of usage of jupyter with beancount!

It really helps!