Pivot table for native SQL question

#1

Hi there, people!
I’m trying to pivot a native SQL query result:
image

But, for some reason…

Any idea?

#2

Columns types are date, text and numeric, for reference.

#3

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:

#4

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.