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
Hey there I've been playing around for a couple of hours with the guide and analytics which fires properly on the UI but wouldn't give me any analytics. I read that there is another script that should be installed for the analytics part of things. Would anyone be able to guide me towards the potential script or some…
All my data is being collected through Firebase I want to export all this data in Amplitude and keep it synced with GA4, I tried adding data sources as BigQuery and GA4 both but for some reason it only partially imported the data and now its not working, I cant even see connected sources. Any help will be appreciated.
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…
