Question

ROLLWINBEFORE

  • 9 February 2024
  • 2 replies
  • 24 views

Hi, I am using this function - ROLLWINBEFORE(UNIQUES, A, 2)

I'd like it to count Uniques A if amount of A in particular period is in range.

For example ROLLWINBEFORE(UNIQUES, A, 2) by month is Number of A per User is >2


Is it possible?


2 replies

Userlevel 4
Badge +2

Hi Yuliia,

I believe what you’re looking for is the inline behavioral cohort functionality. Instead of using a formula, you can create an inline behavioral cohort to segment by users who perform A > 2 times in each interval (e.g. month). Then you can just look at “uniques” of any/active event to see how many users there are. Let me know if that helps!

-Jeffrey

Userlevel 4
Badge +8

Thank you @paladin8 !

 

@Yuliia Dymova  Jeffrey’s answer reminded me of this sweet youtube video that another Amplitude user @Gregor recorded to also compare events (or properties) inline. 

Reply