Funnel chart- how to exclude event before the first step

Hello Kavitha,

Jacenda from Amplitude Support here. I'm happy to assist you today!

I see you're looking to create a funnel between Event A (played a song) and Event B (bought the product) while excluding users who may have purchased in the past and are in a license-expired state before the first step.

To do this, you can use cohorts or user segments to filter out users who have purchased in the past and are in the license-expired state before the start of the date range.

Here are some examples from the Amplitude demo where I've set up a user segment to capture these users:


- Segment of new users: https://app.amplitude.com/analytics/demo/chart/new/spdoekie
- Segment of users who have not purchased before the start of the date range: https://app.amplitude.com/analytics/demo/chart/new/6vzezc07

Also, here are links to our help center articles about defining cohorts and user segments.

I hope this helps! Feel free to reach out if you have any questions.

Warm regards,

Jacenda


P.S. Checkout upcoming events and user meetups on our events page.

Hello Kavitha,

The best alternative for the use case you've described is to use a date range with the 'between' operator instead of the 'last X days offset by'.

Here is an example chart: https://app.amplitude.com/analytics/demo/chart/new/tdhea1qk

I hope this helps! Let me know if you have any more questions.

Best,

Jacenda


P.S. Checkout upcoming events and user meetups on our events page.