Group on sum of distinct values in Tableau

Question

I'm using Tableau 8.3 and I'm trying to find out how to group on each of the values that I find after making a "count of distinct values".

To illustrate the case I have made a fictive dataset that includes 58 rows (buys), 7 different IDs (customers) and 5 different products. Then I have made a count distinct to find out how many of the 5 different products each ID has bought. It looks like this.

ID1 = 4

ID2 = 4

ID3 = 5

ID4 = 4

ID5 = 3

ID6 = 4

ID7 = 2

Now I want to turn the view around and find out how many of the IDs who have bought X different products. It should ultimately look like this.

2 = 1

3 = 1

4 = 4

5 = 1 

I hope to find a solution by posting here! Thank you, 

Answer 1

• You need to update to Tableau 9.0 to achieve that (in a fast way).

• You can create a calculated field named #of products:

{ FIXED [id_customer] : COUNTD([id_product]) }

• Then you can cross the [# of products] with COUNTD(id_customer) to get what you want.

• You need to create a new table in a proper format (1 line per customer with the aggregations) and connect to it in older versions of Tableau.

You can enroll in this Best Tableau Certification course online by Intellipaat to learn basic and advanced Tableau.