Hey folks,
I'm having trouble trying to get a count of users who published more than X amount of ads in a rolling 12 month period.
I'm using WINDOW_SUM functions which do give the count and can identify if they cross the threshold but when i try to do a calculation to count these users it comes out incorrect.
Calculation to count users who had at least 3 ads published in a rolling 12 month period
IF WINDOW_SUM([Number of Ads], -11, 0) >=3 then COUNTD([Nk User Id]) end
i've added a workbook here to play with and a screenshot highlighting the counting issue.
