Spotfire Ideas Portal
We run some very flexible reports which need to allow the user to filter a dataset according to a list they have. As an example this could be a list of 20 or even 1000 materials from a set of 300k materials. To use spotfire filters would be cumbersome.
Would it be possible to have a user area that they could paste/import one or more columns that then via relationships filter a dataset.
Christof solution sounds even easier than mine. Thanks Christof !
You could also import your values as a list (in list panel), then mark from the list and filter to the marked rows.
Hello Sean,
There is a way to do that today.
You will need to import a second dataset in Spotfire containing the list of materials to filter to/out. Let's name it the "Materials" data table.
Create the relation between the Materials data table and the material column in the initial data table (Tools > Data table properties > Relations).
You will see an icon that appear on the filter panel that indicate the relation between the 2 data tables.
Click this icon and choose the preferred filter setting "Filtered Rows Only" or "Exclude Filtered Out Rows".
With this done, everytime the Materials data table is replaced by a user, the initial data table will be filtered by the Materials data table.
Please let me know if this solves your request.