View the original community article here
Last Tested: May 10, 2018
The Problem
We are seeing the suggested values for filters appearing fine in the Explore, but once a value was selected in the filter the suggestions were still listing this particular value.
The Reason
The data in the underlying table may not be cleaned. Instead of a string being "string" it might actually be " string", with whitespaces.
The Solution
Try adding a TRIM() to the code for the field!
sql: TRIM(${TABLE}.columnname);;
This content is subject to limited support.