聚光灯过滤器应用于数据集的所有可视化。

Question

我有一个输入excel文件的以下格式，我想在上面开发一个聚光灯可视化。我看到，当我有不同类型的可视化--比如条形图和饼图，我在其中一个可视化上应用的过滤器，比如饼图( filter =隐藏一种错误代码的贡献)，我看到同样的过滤器也被应用于条形图。如何防止这种情况发生--我的意图是让条形图中的信息按原样显示，而在饼图中，我应该能够省略成功场景(因为如果我们删除了占95%的成功案例，饼焦看起来会更好)。

​

12NC            Error Code      Rev     Message
4022.636.83462  ERROR_BOM_19    AA  Item contains precise BOM View of type 'ASML_Cable'. This is not allowed.
4022.640.89121  ERROR_BOM_19    AA  Item contains precise BOM View of type 'ASML_Cable'. This is not allowed.
4022.640.99082  ERROR_BOM_19    AA  Item contains precise BOM View of type 'view'. This is not allowed.
4022.642.46621  ERROR_BOM_19    AC  Item contains precise BOM View of type 'view'. This is not allowed.
4022.646.43312  ERROR_BOM_19    AB  Item contains precise BOM View of type 'ASML_Cable'. This is not allowed.
4022.656.01171  ERROR_BOM_19    AA  Item contains precise BOM View of type 'view'. This is not allowed.
4022.657.56421  ERROR_BOM_19    AB  Item contains precise BOM View of type 'view'. This is not allowed.
4035.201.14311  ERROR_BOM_19    AB  Item contains precise BOM View of type 'view'. This is not allowed.
4035.201.14541  ERROR_BOM_19    AB  Item contains precise BOM View of type 'view'. This is not allowed.
4035.201.14551  ERROR_BOM_19    AA  Item contains precise BOM View of type 'view'. This is not allowed.
ANCI.634.36431  ERROR_BOM_19    AA  Item contains precise BOM View of type 'view'. This is not allowed.
ANCI.634.68222  ERROR_BOM_19    AA  Item contains precise BOM View of type 'view'. This is not allowed.
ANCI.646.02261  ERROR_BOM_19    AA  Item contains precise BOM View of type 'view'. This is not allowed.
TOOL.646.02261  ERROR_BOM_19    AA  Item contains precise BOM View of type 'view'. This is not allowed.
TOOL.656.05741  ERROR_BOM_19    AA  Item contains precise BOM View of type 'view'. This is not allowed.
REQS.651.79400  SKIP_04             Item is already under SAP Change Control.
REQS.656.04000  SKIP_04             Item is already under SAP Change Control.
REQS.656.26040  SKIP_04             Item is already under SAP Change Control.
REQS.656.63550  SKIP_04             Item is already under SAP Change Control.
REQS.666.33330  SKIP_04             Item is already under SAP Change Control.
4022.431.39244  SUCCESS AD          OK
4022.435.60995  SUCCESS AA          OK
4022.435.62125  SUCCESS AB          OK
4022.436.18892  SUCCESS AA          OK
4022.436.50823  SUCCESS AB          OK
4022.436.50833  SUCCESS AB          OK
4022.436.66971  SUCCESS AB          OK
4022.436.79342  SUCCESS AC          OK
4022.436.79582  SUCCESS AB          OK
4022.437.25653  SUCCESS AE          OK

Answer 1

最简单的方法是通过表达式使用限制。

1. 右键单击可视化，然后单击Properties
2. 打开“属性”对话框的数据页
3. 向下滚动，直到看到通过表达式限制数据，并单击编辑.按钮
4. 输入一个像[Message] != "OK"这样的布尔表达式

另一种方法是创建一个新的过滤方案，并将其分配给特定的可视化，但是这个过程并不那么简单，如果被滥用，可能会导致混淆用户体验。