Skip to main content

Hi, I have a chart where I’ve plotted DAU, WAU, and MAU using the formula bar. For each metric, I want to remove users who onboarded in that timeframe (fired the onboard event), as it inflates the numbers. 

For example:

  • Net DAU = distinct users who visited in the last day - users who onboarded in the last day
  • Net WAU = distinct users who visited in L7 days - users who onboarded in L7 days
  • Net MAU = distinct users who visited in L30 days - users who onboarded in L30 days

How can I do this? Thanks!

Hey @danah 

You can try defining 2 events - any active event and your new user event ( or onboarded event) and use them in a custom formula arithmetic like this  - https://analytics.amplitude.com/demo/chart/new/lmsyfcx

Hope this helps.

Hi @danah ! In addition to Saish’s recommendation above, you can also consider using the right segmentation module to remove users who onboarded in that timeframe. However, you will need behavior offset to achieve this which is only available to customers on Enterprise, Growth, or Scholarship plan: https://help.amplitude.com/hc/en-us/articles/360040965352. If you are not in one of these plan types but are interested in exploring more, I recommend reaching out to our Sales team at global-sdr@amplitude.com. 

Here’s an example of what I’m referring to: https://analytics.amplitude.com/demo/chart/new/2oog2zm

Reply


Terms & ConditionsCookie settings