I want to create a parameter for my pivot table. The problem is that Metabase itself doesn’t support SQL-native queries for pivot tables, and I want to create a custom filter using this parameter.
Is there a way to do this, or is it not possible?
If you created a pivot via the GUI you can filter directly on the pivot ... What issue are you hitting exactly?