Search data in question

Get Help
1

I made a question that just runs a SQL query, and the results are displayed with custom column names and some formatting. I want to add this question to a dashboard so that when people look at it, they can search through the query results. Like if the query returns 1000s of rows of customer info, I want to have a box that they can type in a customer name to find the row corresponding to that customer.

How do I do this? I tried using the filter feature on the dashboard but haven’t been able to get it to work since when I go to add a filter, the question card I added disappears saying “no valid fields”

2

Hi @launc78
You need to insert variables into the query, so Metabase knows where to connect the filter. Have a look in the documentation - I would recommend looking through the entire documentation, there’s a lot of other features:
https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html

3

Awesome! Thank you!