ROLLWINBEFORE

Yuliia Dymova

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?

Find more posts tagged with

Accepted answers

All comments

paladin8

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

Esther Trapadoux

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.

Quick Links

Unanswered Questions

time format on import from Big Query
I am running into a loop when attempting to import data from BigQuery. At origin, my data is already in milliseconds since epoch. If I query: event_time as time, I get the error: 1.'time' column should be a TIMESTAMP_NTZ column (Snowflake) or a TIMESTAMP column (BigQuery). example for the type of 'time' column is…
Import data from one amplitude account to another
How do I transfer data from one amplitude account to another? It seems all the community chats about this have completely broken links. Easy to export, no way to import, very frustrating. :(
@amplitude/plugin-web-vitals-browser build fails on CRA v4 (react-scripts@4.0.3)
When using @amplitude/plugin-web-vitals-browser with Create React App v4 (react-scripts@4.0.3), the build fails with: ./node_modules/@amplitude/plugin-web-vitals-browser/node_modules/web-vitals/dist/web-vitals.js<br /><br />SyntaxError:…
Question about Amplitude Export API Data Delay
Hello, I'm using SpringBoot and Kotlin to integrate with the Amplitude Export API. The official Amplitude documentation (https://amplitude.com/docs/apis/analytics/export) states that "data is available to export at a minimum within 2 hours of when the servers received it." However, there's no clear information about the…
Retrieve via the API users based on a user property
Hello, Is there a way to make a query like: “Give me all the users that have the user property X equal to 10”, by using just any of the APIs, without making a cohort first through the Amplitude’s UI? Thank you!