Knowledge Drop

Why are my filter suggestions showing up several times?

  • 6 April 2021
  • 0 replies
  • 15 views

Userlevel 3
Badge

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!

Reply