Anyone? On Sat, Feb 15, 2020 at 9:31 AM Oon-Ee Ng <[email protected]> wrote:
> I have this query:- > > SELECT > year, month, account, sum(cost(position)) > WHERE > account ~ 'Assets:Banking:Institution:*' > and joinstr(other_accounts) ~ 'Liabilities:CreditCards' > GROUP BY year, month, account > ORDER BY year, month, account DESC > > Works just peachy, and returns 4 columns. Can I merge year and month into > one column? So instead of having (2020, 02) followed by (2020, 01) I'd like > (2020-02) followed by (2020-01) etc. > > Reason is because I'd like to use fava's nifty new 'graph-from-query' > feature =) > -- 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/CAGQ70etH%2Bz%2BZygdjLzJ_2jQQS4RCpU0TtTJCOhkiSBN19Ubihg%40mail.gmail.com.
