• 9 February 2024
  • 2 replies

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 +4

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!


Userlevel 5
Badge +9

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.