## Pages

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

Hello All…

Here I am coming with new challenge. Most of challenges which I have been posting here are not what I faced. Different people colleagues, friends or blog followers sends these challenges. I solved for them.

Click Here to download Data . Use this data set to solve this challenge.

Challenge here to build views shown below.

Step 1:
Showing number of customers by year of order date.

Step 2:
• 595 customers ordered in 2011. Out of 595 Customers 437 customers ordered again in 2012. 136 customers are new customers ordered in 2012.
• Similarly, out of 595 customers who ordered in 2011, 484 customers ordered in 2013. Out of 136 customers who ordered in 2012, 102 customers ordered again in 2013. 51 customers are new customer for year 2013.
• Similarly, out of 595 customers who ordered in 2011, 517 customers ordered in 2014. Out of 136 customers who ordered in 2012, 120 customers ordered again in 2014. Out of 51 customers who ordered customer for year 2013, 45 customers ordered again in 2014.

Step 3:
Calculating percentage with respect to first time when they ordered.
• For 2012 437/595 is 73% customer retention that who ordered in 2011
• For 2013 484/595 is 81% customer retention that who ordered in 2011. Similarly, 102/136 is 75 % that who ordered in 2012.
• Same for rest of the years.