CODEWITHSUNDEEP
data-visualizationspotfire
Jonathan
Jonathan

Reputation: 21

Spotfire 6.0 - Limit Data by Selection from Another Table

I have two data tables A & B in a visualization. They can be joined by a common column ID. Is it possible that the data chart from table B be limited by selection from table A?

Best Regards, Jonathan

Upvotes: 2

Views: 7843

Answers (1)

niko
niko

Reputation: 3974

you can create a relationship based on that ID:

  1. click Edit...Data Table Properties
  2. click the Relations tab
  3. click New to create a new relation
  4. configure the relation by selecting the left and right tables, the column containing the ID on both table, and optionally a method to apply to values in that column
  5. click OK a few times to accept all changes

...and then configure the Filtering panel to show this relationship:

  1. open the Filtering Panel by clicking the button on the toolbar or View...Filters
  2. find the header for your Table B and click the "Filtering" icon next to the expansion arrow (▼)
  3. select Filtering in Table A ► and tick Include

now when you change filters on Table A, data will be limited in Table B to reflect it. only the currently-selected Filtering Scheme will behave like this; any other schemes will also need to be configured (steps 6-8).

Upvotes: 5

Related Questions