2 Replies Latest reply on Nov 13, 2018 2:24 AM by Eduardo Layrisse

    Cohort Analysis for Lifetime value

    Eduardo Layrisse

      Hello everyone. I'm very new to Tableau and I've been trying very hard to find the answer my problem.

       

      I want to calculate the total average orders by an average customer over the last 24 months.

       

      I've tried LOD but can't seem to find a good way.

       

      Below is how we do it in excel. In the top table we use absolute values and in the bottom table we use relative values in order to calculate de average.

      I have all the data necessary but I can't find a tutorial that can help me.

       

      Any suggestions?

       

      Many thanks!

       

      Screen Shot 2018-11-12 at 7.09.43 PM.png