I am attempting to filter users by summing the integer value of an event.
For a purchase event, I want to sum the cost and find out if the user has spent more than X in a specified date range. I want to filter only users that fit this criteria. I have managed to list these by using the aggregate, but I’m not sure how to filter by the sum.
Can you help me set this up in insights please?
Best answer by moinakb
Filtering a report down by values (e.g. show me avg spend broken down by city, but only show cities that have avg spend value > 100) is still on the roadmap and if that is what you are after, I’ll keep you posted when that is ready, but if you are only looking to filter down a report by “users that spent more than $100 between May 15 - May 22”, that is now supported with a new Cohort builder experience like this:
This new experience is still in a beta, so if you’d like to try this out, please send us a message on firstname.lastname@example.org and we will get you set up.