Pivoting more than 3 columns raw data

Hello, as we know, there is pivot feature for table visualization in Metabase. But for activating this function, it is only shown if I have 3 columns. When I tried to get more than 3 columns, the feature is gone. Anyone can help with this?

Hi @mustaninja
Currently Pivot is limited to two dimensions and one metric.
https://www.metabase.com/docs/latest/users-guide/05-visualizing-results.html#pivoted-tables
There’s a request for full transpose:
https://github.com/metabase/metabase/issues/3769 - upvote by clicking :+1: on the first post

Messy fix might be creating a “custom column” using concat() to join the two (or more) values you want to pivot

1 Like

is this problem still not fixed ?
its really important .

@omerfaruk
It’s not a problem, it’s a feature request. Pivot Table (not Table Transpose) will be part of 0.38:
https://github.com/metabase/metabase/issues/8572
You can try the release candidate if you want:
https://github.com/metabase/metabase/releases