Visuals for AND/OR searches

[Clowson]

Hello, 

I have been struggling to even determine if this is feasible, there is not a lot of material on non-finanical BI visuals. Sorry for the poor wording and please let me know ANY thoughts! 

I am creating a Medical history dashboard and I am trying to figure out a way to search by text for multiple conditions using AND / OR logic. 

As of right now, I use the standard text filter and search something like "scoliosis" to identify values from my data that are essentially wildcard "scoiosis". If I use a second text and type "Asthma" I get a sort of wildcard search for any value that has "scoliosis" and "asthma" in the same row. 

My data set is several hundred thousand rows of data and I am looking for a way to search by text for rows by wildcard values. So that if I search "scoliosis" and "asthma" it will look to different lines respectively, and not in the same line. I would like this to be built out to be able to use AND OR logic. IE, search for a patient who has had either condition or specifically both. 

Thank you. 

[lbendlin · Accepted solution]

The advanced filter options in the filter pane allow you to do an OR search of "contains" , but only for two terms.  You can check the market place for custom visuals that may have more options.

[Clowson]

More than two terms from a single column. Using AND OR logic as its linked back to a patient list 

[lbendlin · Accepted solution]

The advanced filter options in the filter pane allow you to do an OR search of "contains" , but only for two terms.  You can check the market place for custom visuals that may have more options.

[Clowson]

Is there any way to have the user do this from the dashbaord? Even two is better than 1. I just use the text filter but that only gets us one, is there a way to enter two lines of text for the same advanced filtering?

I am having a lot of trouble determining if I can build that out. thank you for the help, I am still learning the best way to ask these questions 

[lbendlin]

[SaiTejaTalasila · Accepted solution]

Hi,

You can unhide your reports filter pane and publish your report.I hope it will help you.

[Clowson]

Could you elaborate on this please, how will the user be able to use this?

[lbendlin]

Please clarify:  Are you expecting to be able to search across columns in a row?  Are you expecting to be able to search for more than two terms?