I was able to get it to work: Check your Merge Profile is Edge EnabledMake sure you are counting on the Array, not the Event.  You are counting on the Event. Drag the array in and then change to Agg.Then drag in the "where" field in the same container  

I couldn't stop thinking about this and tried another approach... You can add an aggregation within an event for an Array and it will stay an Edge Segment If we didn't care they were distinct pages we would be done.   But if you do and can't enforce uniqueness in your array on the client side: Go b...

I checked a few things: While the 24-hour is documented as non-Edge, I was able to build a longer lookback, so maybe not an issue?The Aggregation is still a problem. But, if you are open to exploring PQL and seeing if you can make a count() work and still be Edge, check this out: person.orders.sto...

@jean-philippe_8 Your problem is two-fold: Your timeframe is too long if you want to do this on the Edge. You can only do a "Single event within a 24-hour time window"See https://experienceleague.adobe.com/docs/experience-platform/segmentation/ui/edge-segmentation.html?lang=en Any Aggregation "At le...

@yuhuisg I hear you. A few things that sometimes help: Add a Batch_ID to WHEREReplace SELECT * withSELECT [field1], [field2], [field3], [field4] Keep your LIMITIf you know you have a long running query, use CTAS  Hope that helps a little.

@navink386520 Can you post some screenshots of the schemas? I still think this will have a challenge with Profile since even if this works from a relationship standpoint, my expectations are that Segmentation will have some challenges resolving this 1:M relationship due to zip code having multiple e...

@askApr2014 If you are referring to how should your SQL look in Query Service, this is how you get the first element in the array: SELECT identitymap['ECID '][0].ID FROM dataset

@navink386520 To be used on Profile, Time-Series is meant to define an event for an individual, i.e. you need to attach it to an identity of a Profile.  Thus, in the Time-Series you need a Person identity.  You have zipcode as the identity. So, if you want to capture and use weather and apply it to ...

@navink386520 I think the way you are trying to use Weather as an Event, while clever, isn't going to work.  You would need to either: Duplicate the Event to everyone in the zipcode, giving each profile their own event ... OR Use if you want to capture the weather for everybody, everyday Make Weathe...

@Prap I would suggest if the AAM devices Data is the dataset that is causing the issue that you consider disabling it for Profile. Here is more about the datasets from AAM and what they do.  I have even gone so far as disabling additional datasets in some cases. https://experienceleague.adobe.com/do...