Spotfire Ideas Portal
Column filter was taking time/hanging while creating filter due to record count being above 100M unique values. create filter was taking time creating listbox filter by default on that street address column.
As a workaround, while the filter was loading, we changed the type of filter to text filter and killed the filter query running.
Spotfire can enable the feature to default creating text filters for rowcount more than certain amount.In this case spotfire will not try to read huge volume of data from Data source.
Hello Sarath, thank you for contributing. Indeed spotfire has such heuristics to create an appropriate filter type given the characteristics of the data. Can you please describe how you were connecting to the data, like information link, data connection or something else? What data type was the column that caused the problem?