Why are my filter suggestions showing up several times?

[rducarrouge]

Knowledge Drop

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.