Hi there, people!
I'm trying to pivot a native SQL query result:
But, for some reason...
Any idea?
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 Pc3
)
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.