Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Filters
Created by Guest
Created on Feb 3, 2020

Create default text filters for rowcount more than certain amount

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.

  • Attach files
  • Admin
    Niklas Amberntsson
    Feb 4, 2020

    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?