1 Reply Latest reply on Jul 4, 2018 4:00 PM by Deepak Rai

    Analyse purchase behavior with Tableau

    Diana Papukchieva

      Hello,

      i want to analyse the purchase behavior of customers in Tableau.  For my analysis I need the average purchase interval per customer. The calculation which I need should be something like:

       

      -Take the difference between Order Date and the previous Order Date for every customer

      -Calculate the average of this difference for every customer

       

      Can you help me with the calculation? How can I calculate the avage days between the Order Dates and the previous Order Dates per Customer?