1 Reply Latest reply on Jun 13, 2018 4:04 AM by Mavis Liu

    How to?

    Abhinav Srivastava

      Hi Team,

       

      I want to build some retention dashboard.

       

      Want something like this:

                          Month1    Month2......

      Month 1         147          Users who registered in Month1 and played in may too

      Month 2            

      .

      .

      .

        • 1. Re: How to?
          Mavis Liu

          Hi Abhinav,

           

          Would this work?

           

          IF

          { FIXED [Clientid]: MIN(DATETRUNC('month',[Date]))}

          = DATETRUNC('month',[Date]) = false

          then [Clientid]

          END

          then use drag this to text and do a countd of this field. Returns the value of 67:

           

          2018-06-13_12h03_58.png

           

          Thanks,

           

          Mavis