Rotate table in metabase

[dropsun]

Execute me ,how to rotate table as(row changed to column):

[flamber]

Hi @dropsun
That’s called pivot. And yes, Metabase can do that, but currently only if you have 3 columns (one numeric, two groupings):
https://www.metabase.com/docs/latest/users-guide/05-visualizing-results.html#pivoted-tables
Otherwise you would need to do it in SQL - some databases has functions to pivot the result set.

[Helena]

Hi, Flamber currently can I do that with more than 3 columns (one numeric, the rest groupings)?

[flamber]

@Helena More advanced Pivot Tables have been available since 0.38.0 (for some databases)
https://www.metabase.com/blog/Metabase-0.38/index.html

[Helena]

I'm going to see this post. Thank u!