I have a similar issue I need to show one Query in Pivot.
Can I use Views (but how can I pass parameter?).
So that means you create an SQL question without doing aggregation, so it just returns plain rows, and then you use that question as a starting point in the Simple/Custom question, where you then add you aggregation
How can I use a simple question to start point to make complex/custom question?
Hi @flamber Can I create a View and use it a Data ? I created a View and in SQL command I can use it but Pivot doesn't work with sql commands right?? I tried to search my view after click in Admin > Database > myDB > Sync db schema and Re-scan field values and my view not showing on editor.
@Flamber I founded.
others developers using "v_ViewName" for views name. for any reason if I search for v_Metabase don't show nothing. If I search only for metabase shows "V Metabase" I'm not so sure if it's a bug into metabase or not.
@lucas.dj You cannot pass-thru variables to nested queries, so you can use SQL if you want, but without variables, and then use that SQL question as the base.