Want to create pivot table using Mysql queries

Get Help
1

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.

2

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
3

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

4

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