5 Replies Latest reply on Nov 26, 2018 9:20 AM by Deepak Rai

    Count non active users

    Pavel Sayenko

      Hi, everyone!

      Need some help with next issue:

      I have list of users actions, e.g.

       

       

      dateid
      01.01.2018a1
      04.01.2018a1
      05.01.2018a1
      06.01.2018a1
      01.01.2018b2
      02.01.2018b2
      05.01.2018b2
      06.01.2018b2

       

      As you can see, there are missed few dates:

       

      datesid
      02.01.2018a1
      03.01.2018a1
      03.01.2018b2
      04.01.2018b2

       

      I need count unique id for each missed date and get something like this:

       

      datecountd(id)
      01.01.20180
      02.01.20181
      03.01.20182
      04.01.20181
      05.01.20180
      06.01.20180

       

      Any ideas?

      Thanks