Search Filter for Reporting Chain

Question & Answer
, , , , , ,
1

I am looking to create a filter that allows me to search for names across multiple columns within a dataset. How can I create such a filter? I’ve attached a sample dataset where I’d like to search for a name from all columns using free text instead of a dropdown filter.

image

image

2

Hi @wirkuty, there are two approaches:

  1. You can create a parameter control with text field style, and then link the parameter with multiple custom filters created for different fields. Also, making sure you are using “OR” to combine different filters.
    Using this approach, you will be able to use the parameter control to search for multiple fields.
    36ca78df2c62a8b403361b1c78111f1c0029dffd

Credit to @emilyzhu

  1. A quicker approach might be to use concat() to create a single field which you can apply
    your filter to. So you would create a new field that contains all other text fields as follows:
concat(field1, field2, field3....)

See Concat - Amazon QuickSight

Credit to @darcoli

We hope this solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking this answer as a “Solution.” (click the check box under the reply)

3

Thank you so much for your response! What would I use for the calculated field for the parameter?

4

Nevermind! I was able to figure it out. Thank you so much for your help!

1 Like