I'm using an input control in Looker and need to exclude the text entered into it.
This will be a way to exclude branded search from the Query field using Search Console data. I.e. If "apple" is entered into the text input, the table will exclude any queries with "apple" in it. I've tried parameters and most recently tried setting input search type to Regex with a calculated field (below) that negates the query string entered, but I don't think I have this right.
CONCAT("^(?!.*",LOWER(Query),".*$).*$")
Has anyone successfully used an input control to EXCLUDE an entered string instead of INCLUDE it?
LinkedIn
Twitter
