Spotfire 6.0-通过从另一个表中选择限制数据 [英] Spotfire 6.0 - Limit Data by Selection from Another Table
问题描述
我有两个数据表A& B在可视化中。它们可以通过公共列ID联接。
是否可以通过选择表A来限制表B中的数据图表?
最好的问候,
Jonathan
您可以基于该ID创建关系:
- 单击编辑...数据表属性
- 单击关系选项卡
- 单击新建以创建新的关系
- 通过选择左右表,包含两个表的ID的列以及可选的方法来配置该关系应用于该列中的值
- 单击确定几次以接受所有更改
。 ..,然后配置过滤面板以显示这种关系:
- 打开过滤面板通过单击工具栏上的按钮或查看...过滤器
- 查找表B的标题,然后单击旁边的过滤图标e展开箭头(▼)
- 选择表A中的过滤器► 并勾选 Include
现在,当您更改表A上的过滤器时,表B中的数据将受到限制以反映出来。只有当前选择的过滤方案才会表现为这种情况;其他任何方案也都需要配置(步骤6-8)。
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
you can create a relationship based on that ID:
- click Edit...Data Table Properties
- click the Relations tab
- click New to create a new relation
- 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
- click OK a few times to accept all changes
...and then configure the Filtering panel to show this relationship:
- open the Filtering Panel by clicking the button on the toolbar or View...Filters
- find the header for your Table B and click the "Filtering" icon next to the expansion arrow (▼)
- 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).
这篇关于Spotfire 6.0-通过从另一个表中选择限制数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!