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
Hi everyone, We're using Amplitude's S3 export and noticed that for every export batch, two files are created in our bucket: 1. A `_complete` file (0 bytes, seems to be a flag/marker) 2. A `.json.gz` file (the actual event data) The actual data lives entirely in the `.json.gz` file, so the `_complete` file doesn't seem to…
Hello, We have a blank screen after adding in Amplitude/Session replay into our app, it seems like some windows appear for a breif second before dissapearing back to the black screen. Currently are app is NOT using Jetpack compose. This is on a samsung active 3,
Hi, I set integration between Amplitude and Appsflyer(V1) - I see that integration is active but when I'm trying to check this integration in Amplitude section “Connect AppsFlyer” on the second step I see “Listening..” and nothing happend. Does this second step show any activity only if I begin sending events from…
I want to be able to identify and track the users that are hitting a specific page (feature) that is limited by our product tiering in our multi-tenant SaaS app. Our customer businesses have their own segmented dashboard based on the subdomain of the app url (somebusiness.ourapp.com), and I have figured out how to capture…
Hi there, I'm trying to integrate the surveys for react native feature to our app. I've followed the guide and I verify the plugin is "booted" correctly (right user id and device id) but when opening a link, while the linking handlers are correctly triggered, the call to handleURL is returning false - I've verified the url…
