When creating a case when statement and referring to text in Looker, if the text has an apostrophe I cant seem to classify it as text:
Case when field = ‘don’t’ as an example it wont pick up that the condition is text. The apostrophe in “don’t” is creating an issue. How do I get around this?
Thanks!!!