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:
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
Retrieving data ...