Tableau 简明教程
Tableau - Condition Filters
Tableau 中一个重要的筛选选项是对现有筛选器应用一些条件。这些条件可以很简单，例如仅查找高于一定金额的销售，也可以基于某个公式来查找复杂条件。还可以应用条件来创建范围筛选器。
One of the important filtering options in Tableau is to apply some conditions to already existing filters. These conditions can be very simple like finding only those sales which are higher than a certain amount or it can be a complex one based on a certain formula. The conditions can also be applied to create a range filter.
Creating a Condition Filter
使用 Sample-superstore，让我们找到所有细分市场中其销售额超过一百万的子类别产品。为实现这一目标，以下是步骤。
Using the Sample-superstore, let’s find that sub-category of products across all segments whose sales exceed one million. To achieve this objective, following are the steps.
Step 1 − 将维度细分和度量销售拖放到列功能区。接下来，将维度子类别拖放到行功能区。选择水平条形图选项。您将获得以下图表。
Step 1 − Drag the dimension segment and the measure Sales to the Column shelf. Next, drag the dimension Sub-Category to the Rows shelf. Choose the horizontal bar chart option. You will get the following chart.
Step 2 − 将维度子类别拖放到筛选器功能区。右键单击进行编辑，然后转到条件选项卡。在此，选择按字段进行单选按钮选项。从下拉菜单中，选择销售额、总和和大于或等于符号，并指定值 100000。
Step 2 − Drag the dimension Sub-Category to the Filters Shelf. Right-click to edit and go to the tab Condition. Here, choose the radio option by field. From the drop-down, select Sales, Sum and greater than equal to symbol specifying the value 100000.
在完成上述两个步骤后，我们得到一张图表，该图表仅显示满足条件的销售额达到所需金额的产品子类别。此外，还会针对满足条件的所有细分市场显示此内容。
On completion of the above two steps, we get a chart which shows only those subcategory of products, which have the required amount of sale. Also this is shown for all the available segments where the condition is met.
