Currently formula like Uniques(A) always refer to the events of each time period. It would be nice to be able to refer to previous time periods via something like Uniques(A-1) in order to create a formula that combines both.
Currently I do this with a math hack using the rolling average and rolling window functions.
I’m looking for this, too!
Specifically, I’m trying to build a chart for subscription churn:
“Started or Renewed Event in the LAST period” (e.g, the count of active subscribers at the start of this period)
➗
Expired Event in THIS period
Any help appreciated.
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
