Is there a way to filter a card based on a sub-string in a text field?

mberkeley
mberkeley Contributor
in Charting

I have a text field that is delimited by '|'. I would like a user to be able to use a quick filter that allows users to find a sub-string of the text field.

Regions Covered

Row1: North|South|East

Row2: East|West

Row3: West

Row4: East|South


I would like to be able to filter if a row contains 'East'.

(Yes, I know I could do some magic to unpivot these values, but the # of rows would be obscene and there is limited value in keeping all those rows).

Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Hi @mberkeley

    You can use the Contains filter on the quick filter. You just need to make sure you set the quick filter to use the "Match Values" option in analyzer and then the user will be able to select "Contains" as the filter option.

    Screen Shot 2021-03-19 at 12.55.45 PM.png Screen Shot 2021-03-19 at 12.56.10 PM.png


    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Hi @mberkeley

    You can use the Contains filter on the quick filter. You just need to make sure you set the quick filter to use the "Match Values" option in analyzer and then the user will be able to select "Contains" as the filter option.

    Screen Shot 2021-03-19 at 12.55.45 PM.png Screen Shot 2021-03-19 at 12.56.10 PM.png


    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories