Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
jpapador
Partner - Specialist
Partner - Specialist

Peek function to solve for X

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?

1 Reply
Gysbert_Wassenaar

I don't understand what you're trying to do. Can you explain with some sample data what you're trying to calculate?


talk is cheap, supply exceeds demand