Given a raw list of transactions similar to the following (this is the raw data source):
1) I want to evaluate, for each customer, the time between this customer's first transaction ever, and the moment this customer reaches $1,000 of (so-far) lifetime value.
Hypothetical example: customer A reached $1,000 of LTV in 62 days, while customer B reached the same LTV in 45 days.
2) Then, I want to be able to use this time-to-reach-some-LTV as a dimension/measure, that I can re-use in various charts. For instance, I'd want to plot the distribution of time-to-LTV for various customer segments, or to plot the average time-to-LTV as a function of customer's first shop he made his first transaction in. Or, I'd like to plot the average customer LTV (current) based on bins of time-to-reach-some-LTV. For instance, what's the current average LTV for customers who reached $1,000 in 20-30 days? And what's the average LTV for customers who reached $1,000 in 30-40 days?
Q: What would be the best way to accomplish both these things in Tableau (using Tableau Desktop)?
Could you prepare sufficient size of data which includes several customers which reached 1000.
and from the conclusion, that can not be done by one data source.
You need to create one table then export that data to the file as another source to use the values for another analysis.