4 Replies Latest reply on Mar 17, 2016 12:44 PM by Kent Sloan

    How to create continuous graph from multiple measures (specifically, retention curve)

    Kyle Campbell

      Hi all,

      I have a dataset that flags whether a user showed up on a specific day after they first used an app. So I have individual measures for day 1-7, day 14 and  day 28 retention that looks like this:

       

      IdTypeD0D1D14D2D28D3D4D5D6D7
      0b1001010000
      1a1100000000
      2c1100010000
      3b1001000000
      4c1100001000
      5c1100000100
      6c1000010000
      7b1100000100
      8a1001000000
      9b1101010000

       

      I want to get a comparison of retention by type. But instead of a simple Measure Names/Values table like this:

      TypeAvg. D1Avg. D2Avg. D3Avg. D4Avg. D5Avg. D6Avg. D7Avg. D14Avg. D28
      a50.61%35.59%24.90%20.26%0.17620.146113.49%10.39%10.23%
      b50.53%31.78%24.45%19.22%0.16290.142611.66%11.16%10.03%
      c50.32%33.41%24.59%20.00%0.16790.139511.84%11.06%10.55%

       

       

      I want a graph, that shows the different retention curves overlaid, preferably with days filled out all the way to day 28 (excel'd):

       

      I haven't been able to figure out a way to do it. Anyone have an idea?

       

      I've attached an example workbook with dummy data similar to my own.

       

      Thanks!