Do you feel that you are Tableau Expert? Then try this challenge 6

Here I am coming with real time challenge. Those who are interested can try this and test your knowledge.

Initially some body asked me to post real time challenges. I am getting good responses to these posts. These challenges are to test your knowledge. I am not challenging anybody here to solve. I am just alerting people by using sentence “Do you feel that you are Tableau Expert?”. If really solve my challenges you will become expert definitly. How you are thinking is very important while solving challenges.

Here we go with one more challenge:



In Above image at bottom, you are seeing 1,2,3….. 17. These are Number of Orders by Customer.

Color Indications:

Blue – Number of Customers does not return any Order. Means Zero Order returned.
Green – Number of Customers who returned only 1 Order.
Red – Number of Customers who returned only 2 Order.
Purple – Number of Customers who returned only 3 Order.

Explanation 1:

Now lets take bar which is showing 1 at bottom of the image.
Assume that 100 Customers placed only one Order. In that 100 Customers 92 people not returned any Order. But 8 People returned one Order.

Explanation 2:

Now lets take bar which is showing 12 at the bottom of the image.
Assume that 100 Customers placed 12 Order per each Customer. In those Customers 39 people not returned any Order. But 39 people returned only one Order, 17 people returned only 2 orders and 6 people returned 3 orders.

Explanation 3:

Now lets take bar which is showing 17 at the bottom of the image.
Assume that 100 Customers placed 17 Orders per each Customer. But non of them were not returned any Order.

Note: Please download the Data from below link to solve this challenge. If you use this data result should match with above image.

ClickHere to download Data


For more challenges: Click Here