1 Reply Latest reply on Aug 31, 2018 2:25 PM by Patrick Van Der Hyde

    Calculate daily D1 retention rate

    Nolan Esser

      Hello everyone and thanks for reading this,

       

      As the title suggest, I have some struggle calculating the daily D1 retention rate of my datas.

       

      The result I would like to achieve would looks like this:

       

       

      The first day is 0% because you don't have any datas the first day. The second day you start having second day datas to compare it to the first day datas and so on to

      This percentage represents the people that connect and that came back the day after.

      I use event_timestamp for the dates, user_id to identify people. I created FTL to return the date of first connection. There are a lot of other datas that can be used if you understand them, I am really sad I did not succeed by myself but I have not a lot of experience on Tableau.

       

      Regards,

       

      Nolan