Not sure.  Did you try PQL? distinct().count()  

@ChetanyaJain from what I can tell the Edge Network Server API uses Events.  I couldn't find anyway to update the Edge Profile directly.

@an1989 I built this in the UI.     Here is the PQL: CHAIN(xEvent, timestamp, [C0: WHAT(true) WHEN(<= 10 days before now) COUNT(ALL) WHERE(C0[productListItems.exists(SKU.isNotNull())].count() >= 2 and C0[productListItems.exists(SKU.isNotNull())].count() <= 5)])

@ChetanyaJain This one is tricky and the short answer is I have not found a way.  But let's walk through it. The Edge only knows about the current hit/event and therefore Edge Segments must use either Profile attributes or a single hit to evaluateTo get a Segment to evaluate using only the "last" hi...

@Luca_Lattarini Keep in mind the purpose of _id is to prevent duplicates from being loaded into AEP. What I prefer/suggest people to do is take a concatenate multiple columns approach. e.g. LastUpdateTimestamp+OrderID  

@an1989 A few things to remember: Segments do not produce an "audience count".  They are rules that define if someone qualifies for membership in a Segment.You can do a Count of Purchases (not Count Distinct) using Aggregate functions in the UI. https://experienceleague.adobe.com/docs/experience-pla...

@Luca_Lattarini @ChetanyaJain When you say "no preference", I want to make sure I understand... In the test you did you are saying field 2 ended up being? [field doesn't exist on profile]"def" Also, just wanted to make sure you loaded the data in the order laid out in the example.   Thanks for testi...

That sounds good to me.

@Robsayz If you want all the identities exported on a daily basis to a dataset, use the Profile Snapshot Export xxx system dataset.