This content has been marked as final. Show 2 replies
Consider this sample data source -
Using this datasource, I am able to visualise new clients every month by using a simple Difference aggregation on the count of User ID, and the cumulative count of clients per month. Here is my question -
As you can see, User with ID 1 has churned out in Jan as it no longer appears beyond Jan. I am trying to plot the churned clients count per month using the provided data source but am failing to do so. How do I achieve this?
Any suggestion on solving this using Tableau or modifying the data source's design itself (although a charting tool should be easily able to derive this data from the given design) would be most welcome, thanks in advance!