Hello, I’m just getting started setting up alerts for some of our key metrics. One thing I’d like to do is trigger an alert if a metric is a certain percentage higher than it was 3 months ago. I see our options are comparing to the previous day’s value and the previous week’s value but no option beyond that. Is it possible to compare data values from further back? Thanks!
Best answer by Saish Redkar
View original
+10
Hey
Alerts can be set only on a daily or hourly interval chart.
From the current default options, it looks like only previous day’s value and the previous week’s value is available for comparison. I can see some value in how it might help to compare it to a higher custom time interval for alerting. Here’s the idea section where in you can submit this as a potential feature idea.
You can try using the Compare to past feature on the event seg chart to go beyond a custom date range, but not aware of any direct workaround to combine this with the alerts capability.
Hope this helps.
Thank you
PROPAVG(A)/PROPAVG(A, -90)Is this in any way possible?
Update: I’m trying the Compare to past feature you mentioned and seeing if I can get alerts to fire when the ratio falls below a certain threshold.
+10
I don’t think PROPAVG formula can take in the days parameter.
You can play around the ROLLWIN formula If the use case fits.
Maybe something like this - ROLLWIN(PROPAVG, A, 90)
Looks like the Compare to past feature gives us what we need. With that we can compute the differences between 3-month timespans and set up an alert if that difference reaches a certain threshold.
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.