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.