Knowledge Drop

Why are my filter suggestions showing up several times?

Userlevel 3

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.                


0 replies

Be the first to reply!