Tableau 过滤重复项 [英] Tableau Filtering on duplicates

问题描述

我有一个与此类似的数据集:

I have a dataset that looks similar to this:

如您所见，有些 ABN 附加了多个公司名称，而其他的只有一个.我想创建一个过滤器，允许用户只查看每个 ABN 有多个名称的那些行.例如，过滤器将过滤掉 ABN 456.

As you can see some ABNs have multiple business names attached while others have just one. I want to create a filter that allows the user to see just those rows where there are multiple names to each ABN. For example, a filer that will filter out ABN 456.

我可以想象我将如何用 SQL 编写它，但无法理解如何在 Tableau 中执行它.任何帮助将不胜感激.

I can imagine how I would write that in SQL, but cannot get my head around how to do it in Tableau. Any help would be appreciated.

推荐答案

我认为最简单的方法是通过条件过滤器.

I believe the easiest way to do that is through a conditional filter.

1) 拖动 ABN 进行过滤

1) Drag ABN to filter

2) 转到条件"选项卡

2) Go to the Condition tab

3) 选择按字段、记录数、总和、>、1

3) Select By field, Number of records, Sum, >, 1

这样您就可以过滤具有超过 1 条记录的 ABN.如果您有更细粒度的数据(例如，金额的不同分类)，并且记录数不是您要查找的确切数据，则可以使用 BUSINESS NAME, Count(Distinct).这是您需要的防弹工具(虽然速度稍慢)

That way you're filtering ABNs that have more than 1 record. If you have more granular data (e.g. different classifications of the amount), and Number of Records is not exactly what you're looking for, you can use BUSINESS NAME, Count(Distinct). That is bullet proof for what you need (though a little slower)

这篇关于Tableau 过滤重复项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！