Hi there, people!
I’m trying to pivot a native SQL query result:
But, for some reason…
Columns types are date, text and numeric, for reference.
Pivot was changed in version 0.31 to fix a lot of issues, but also introduced another issue, so it can only pivot numeric fields (in your case, you would have to set the Pivot column to
There’s an issue open - go and upvote:
Wow… that renders the pivot feature almost useless currently, I suppose, since very rarely would one want to see numbers for number x number… Thanks for the answer, and hoping this rather nice feature is brought back again.