8 Replies Latest reply: Dec 27, 2010 10:16 AM by isaac li RSS

    About retention rate

    isaac li

      Hi all,

      I was wondering how to calculate retention rate:

      I load the raw data into QV:

      OrderId MemberId Amount

      1 1 $30

      2 1 $35

      3 2 $30

      4 2 $30

      5 3 $11

      I want to use an object to show how many people buy 3 times, 2 times, 1 times and so on.

      In this sample, the results should be:

      2 times: 2

      1 times: 1

       

      How can I achieve it and I should use which object to show?

       

      Thanks.