Design a view to see all of my customers who have returned and bought again over time.(Renewals).
Add quarters to columns (right click and drag for dialogue box to open)
Add Customer Name to rows
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?
Count customers who have renewed only once
Create a calculation that sums up the counts of renewals
Modify the calculation so that only one instance of the sum of renewals remains.
Compute each calculation appropriately.
Create final viz
Put Final Renewals on the Rows shelf
Put Customer Name on Details
Break Final Renewals up by Segment.