Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (17.6k points)

I have a dataset that looks similar to this:

enter image description here

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.

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.

1 Answer

0 votes
by (47.2k points)

The best way is to do this through a conditional filter.

1) Drag ABN to filter

2) Go to the Condition tab

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

Filter in such a way that, ABNs 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 proof for what you need (though a little slower)

If you want to learn more about tableau analytics then you can check our Tableau Course online.

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Dec 9, 2020 in BI by Chris (11.1k points)

Browse Categories