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 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