View the original community article here
Last tested: Jul 30, 2019
If you see odd results in a drill's filter string, it may be that the strings content has a character that Looker is trying to escape.
Characters like - Looker is trying to escape, so we need to do something to avoid that.
To avoid this, you'll want to replace the character(s) that Looker is trying to escape using something like the REPLACE function. This way both the field and the filter results will have the proper character string for filtering.
dimension: name
sql: REPLACE(${TABLE}.name_field, "-", " ")
This content is subject to limited support.