I want to configure a eligibility condition in one of the offer, I have to do some aggregation inside the eligibility tab of offer.
Consider I have customer & transaction schema, I want to make this offer available for people who have done 3 orders consecutively in past 10 days
So I want to group by on customer id & count of order id is 3 in last 10 days.
So how do I configure this with the raw transactions without using workflows inside the offer tab only.
I've confirmed with engineering that this case is too advanced to serve with the filtering option available in the eligibility conditions of an offer. You'd have to use a workflow query to be able to do that, with a condition link on your transactions where you filter on the last 10 days, and then add an output filtering with count > 2.
Unfortunately it seems that one can't be done directly from the offer eligibility rules.