Redash has filters for query results and visualizations! Thanks to filters, you can restrain the result to a specific or multiple values. Filters are enabled by following a naming convention for columns.

If you want to focus on a specific value, you'll need to alias your column to  <columnName>::filter . Here's an example:

<code>SELECT action AS "action::filter", COUNT (0) AS "actions count" FROM events GROUP BY action


If you're interested in multi filters (meaning you can select multiple values), you will need to alias your column to  <columnName>::multi-filter. Here's an example:

<code>SELECT action AS "action::multi-filter", COUNT (0) AS "actions count" FROM events GROUP BY action


Note that you can use  __filter or __multiFilter, (double underscore instead of double quotes) if your database doesn’t support :: in column names (such as BigQuery).