5 Replies Latest reply on Sep 11, 2017 6:18 AM by Joshua Cloud

Count of customers with more than n orders, by country, in packed bubble chart

cherillin.gritton Mar 17, 2016 11:31 AM

Hi Tableau gurus,

I have been breaking my head trying to solve this problem on a proprietary dataset. I have tried using the SuperStore dataset hoping that a simpler dataset would help, but to no avail. I've attached a packaged workbook.

In the parlance of the SuperStore dataset, I know that there are some customers that only have one order and others that have two or more Order IDs. I would like to count, by country, customer IDs that have 2 or more distinct Order IDs. For example, Customer ID 2 who lives in the US has only one order, and so I would not want to count that customer in the total for the US.

Once I know how many customers in each country have two or more orders, I'd like to display a packed bubble chart with country names and the multi-order customer count.

I've played around with various table calculations but can't get anywhere that makes sense. I'm sure it can be done! Thanks for any help you can provide.

Count of Customers with multiple orders by country.twbx 1,004.9 KB

1. Re: Count of customers with more than n orders, by country, in packed bubble chart

Joshua Cloud Mar 17, 2016 12:07 PM (in response to cherillin.gritton)
Cheril,

Try using this calculation on the sample data:

Count of Customers with multiple orders by country.twbx 1,015.2 KB

1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Count of customers with more than n orders, by country, in packed bubble chart

cherillin.gritton Mar 17, 2016 12:52 PM (in response to Joshua Cloud)

This looks really awesome! However, I am stuck using Tableau 8.2 for this particular project. Do you have any other ideas?
Like Show 0 Likes(0)

Actions
3. Re: Count of customers with more than n orders, by country, in packed bubble chart

cherillin.gritton Mar 17, 2016 1:25 PM (in response to cherillin.gritton)
I ended up solving my own problem using this blog post: Slicing by Aggregate | VizPainter .

I needed to first create a set of Customers that had more than one distinct order number, and then I could use that set as a filter. I had tried that, but I wasn't doing it right. I've attached the workbook with the solution.

Count of Customers with multiple orders by country solved.twbx 984.2 KB
Like Show 0 Likes(0)

Actions
4. Re: Count of customers with more than n orders, by country, in packed bubble chart

Michael Chen Sep 10, 2017 1:50 AM (in response to Joshua Cloud)

Found your post while trying to find a List of Order ID that involve more than one Country.
Based on the original question of this post, should the calculation use COUNTD instead of COUNT? Thx
Like Show 0 Likes(0)

Actions
5. Re: Count of customers with more than n orders, by country, in packed bubble chart

Joshua Cloud Sep 11, 2017 6:18 AM (in response to Michael Chen)

yes
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

Count of customers with more than n orders, by country, in packed bubble chart

1. Re: Count of customers with more than n orders, by country, in packed bubble chart

2. Re: Count of customers with more than n orders, by country, in packed bubble chart

3. Re: Count of customers with more than n orders, by country, in packed bubble chart

4. Re: Count of customers with more than n orders, by country, in packed bubble chart

5. Re: Count of customers with more than n orders, by country, in packed bubble chart

Actions

More Like This