Thanks for attaching the sample data. I'm not sure if this is the most elegant solution or not as it does involve quite a fair number of nested calculated fields, but it does let us show the bar chart you created in Excel. I attached a workbook (used Tableau 9.2) and have included a screenshot below of all the different worksheets I made to validate the calculations.
One area to pay attention to is that the table calculations need to have their advanced Compute Using settings entered (accessed by right-clicking the field on the viz > Edit Table Calculation > select Advanced in the Compute Using drop down).
Hopefully this helps get you started on your analysis. Thanks!
customer retention.twbx 81.6 KB
This is great! One question, I have millions of user ID's and just to do a count of them in each periods by bucket in a table format. I've tried using your example but can't get it to work. Do you have any suggestions? Thx!