1 Reply Latest reply: Oct 3, 2013 12:49 PM by Gysbert Wassenaar RSS

    Peek function to solve for X

    Jared Papador

      Not sure if peek is the best way to do this, but what I am trying to figure out is looking at an organization, how many users does it take until there average sign in count per week is 1.

       

      My initial thought is to sort by user and find there average, if it is not equal to 1 then move to the next line and find there average.  My only issue is that can you use peek to say, evaluate line 1, then evaluate lines 1 and 2, then evaluate lines 1, 2 and 3 and so on until your average equals 1.

       

      Hopefully I am making sense, is there a way to do this?