Thursday, 21 July 2016

Finding Renewal of subscriptions

Design a view to see all of my customers who have returned and bought again over time.(Renewals).


Step 1:- 
Add quarters to columns (right click and drag for dialogue box to open) 




Step 2:-
Add Customer Name to rows 



Step 3:-

Count customers who have renewed

Create a calculation that checks if the customer's current purchase is greater than 0 and if the previous purchase was greater than 0. 

In other words, did the customer purchase more than once in a row?


Step 4: 

Count customers who have renewed only once

  Step 4.1: 
  Create a calculation that sums up the counts of renewals 
  Step 4.2:
   Modify the calculation so that only one instance of the sum      of renewals remains.  

     Step 4.3: 
     Compute each calculation appropriately.



Step5:

Create final viz

  Step 5.1:
  Put Final Renewals on the Rows shelf


    Step 5.2: 
    Put Customer Name on Details 



     Step 4.3:
     Break Final Renewals up by Segment. 




Thanks Guru's,
Prazval.ks


Formatting Tips

Hello Gurus, One of the common things in Tableau after building any visualization is performing formatting. The Structured way of doing i...