pivotpivot-tableunpivotmetabase

Does metabase.com support SQL PIVOT and UN-PIVOT?


I am trying to do PIVOT in SQL in metabase.com. Facing multiple errors which executing. Any one tried SQL PIVOT in METABASE.

If anyone faced similar issue or any solution for the same


Solution

  • Yes, it's possible.

    You have to save your query as a question, then you go to the GUI editor and use your saved question as data to the analysis.

    And in the end, after run the query, you will be able to use the pivot table feature clicking in "display".