A dashboard viewer should select a region and have that value affect the underlying SQL query. Which approach is appropriate?

1. Concatenate unchecked input directly into SQL text
2. Add a region filter only to a chart while requiring the SQL query itself to remain unfiltered
3. Bind a supported dashboard parameter to a named query parameter
4. Change the parameter default but leave the dataset query unbound