Hi community,
I’m trying to create something like the attached picture
is it as simple as looking at unique users group by week?
trying tp create something like this where i assume its a rolling period?
Yea, ROLLWIN(UNIQUES, A, 30) will give you rolling 30 day uniques per datapoint.
Hey Omriko
You can use this custom formula to chart out DAU/MAU :
UNIQUES(A)/ROLLWIN(UNIQUES, A, 30)
You can read more on these in the following posts -
Hope this helps.
Thank you, and if i want the flat numbers of the window, just remove the first part right (nominator)?
Thanks!
I have another question, sorry as I'm a bit confused.
If I wanted the daily active users, just as simple as that, what would I need to do?
I want to see daily active users not events..
Should I use the segmentation chart → any active event -→ group by user ID?
Saish Redkar
Omriko
Responded in this
Saish Redkar i’m using your UNIQUES(A)/ROLLWIN(UNIQUES, A, 30) but as a followup to this, i’d want to take out non-working days to prevent this chart behavior:
which is caused by weekends when close to zero users are using our B2B saas tool 😁. Any thoughts?
update: i’ve just read up here that it’s not possible and would be a feature request
klaas
They now have the “Event Day of Week” property filter wherein you can chose the days if you have access to that. Not sure if this is GA to all customers or not yet.
I tried charting the 30 day rolling win formula - with weekends vs without weekends in this demo chart
So I’m assuming every datapoint in there will have the rolling sum of the past 30 days excluding any data from a Saturday and a Sunday.
Hope this helps
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…
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. :(
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:…
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…
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!
