0 Replies Latest reply on Nov 26, 2018 10:09 AM by Pavel Sayenko

    View of missed users

    Pavel Sayenko

      Kindly asking community for a help

      There is dataset in attach. There are 2 colomns: dates and user id. Some ids missed in set and my goal is find them out.

      Moreover it must be done through custom conditions like this:

       

       

      1-21110
      3-51110
      5-100110
      >100122
      JanFebMarApr
      a1 add to 3-5 (no data from 11/01 till 15/01)
      b1 add to 1-2 (no data from 11/01 till 12/01)
      b1 add to each group (no data at all)
      a1 add to each group (no data at all)
      b1 already there
      Both a1 and b1 in >10

       

      So, my idea was: DATEDIFF('day', LOOKUP(ATTR(date), -1), ATTR(date)), but it doesn't work, maybe I did something wrong.

      I've tried window_sum/count and so on, but still got nothing.

       

      Thank for any thoughts