Want to create pivot table using Mysql queries

Hi all, I am trying to write a mysql query and then want to convert table into a Pivot table.In this case, the option for pivot table is not appeared in visualization. Can someone please help with it.

There are some limitation around using SQL and pivot ... Have a look at this since there is a workaround by using the SQL as a question inside the notebook editor

1 Like

Thanks for a response.
But in this how to convert parameterized sql query into a model.

You will need to add the filters at dashboard level by mapping the information in the metadata ... Check Model metadata