My team and I are working on an LTV analysis and need some help generating a specific graph.
We are attempting to show when the average customer pays us back and how that relates to our Average Lifetime Revenue and Average Customer Lifespan metrics.
What we would like to show is the curve leading up to the ratio between these two metrics.
We have attempted to drop User Id and Segment Id on the Marks shelf to show the breakdown and then generate a trend line but the trend line does not appear to approach the final ratio.
The attached workbook provides a sample dataset and calculations that shows the average payback reference line and the ratio we would like the curve to end at.
Any thoughts, feedback, questions or help would be greatly appreciated!
I see it's been a few weeks since you asked this question, are you still hoping for help? Have you tried submitting a support ticket at customer.tableau.com?