Forum Discussion
Visuals for AND/OR searches
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.
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.
Hi,
You can unhide your reports filter pane and publish your report.I hope it will help you.
7 Replies
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?
More than two terms from a single column. Using AND OR logic as its linked back to a patient list
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.
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