What’s best practice for finding the fraction of users (who perform event A) that perform an event A (at least) once every day of the week?
I have tried a solution to use a Segmentation chart with two segments:
- Users who performed event A >= 7 times
any time in each week - Users who performed event A >= 1 time
any time in each week
On the left hand side I chose Any Active Event,
using this formula: %: UNIQUES(A1)/UNIQUES(A2),
with frequency weekly.
My understanding is that this will give me the fraction of event a users that performed event A >= 7 times of the users who have performed event A >= 1 time. However, the “in each” option will include user who performed event A at least X times during each chart interval, which does not met my intended wish to guarantee that each user in segment 1 have performed event A at least once each day, for example a user would also be included if they performed the event 5 times on Monday and 2 times on Saturday...
In short, is there a way in Amplitude which can only count user that have performed an event at least once each day on a weekly basis? Or do I simply need to analyzing the raw event data outside of Amplitude?
Grateful for any help, explanation!
Thanks in advance,
Nils
