The values in this field are all short (4 or 5 character) strings, but in the Explore Looker is displaying all of them with what looks like the letter phi (middle column):
when I attempt to drill down into one of them, it brings up a filter that shows the actual string, but if I do try to use the filter, it throws an error. Is there a known display issue? Gemini points to character set encoding, but that seems unlikely.
Solved! Go to Solution.
Interesting case 🤔 I would also test if COALESCE(your_field, 'Unknown') returns 'Unknown' everywhere and check if the auto-generated query uses joins that might produce null values.
Is type: string explicitly set in the dimension definition? Also, what error message do you get when applying a filter to that field?
JuliaK, you are my favorite person on the internet today. In the view, I had the record type configured as number, but it's a string. When I checked the error message you pointed me to, it told me "invalid number format" or something similar. Went back and fixed the view, now it's working perfectly. Thank you!