Thank you. This approach worked. 

How to use countif in workflow/query? I am trying to get to the highlighted values (count of states that have a a group value greater than 0).  

Thanks. I am specifically asking about the Add to form a group. How different is that from using nested containers?

I have a question regarding the Segment Builder canvas within AEP. I am talking about the Build Rule option, not the Audience Composition canvas.What does the 'Add to form a group' do? In other words, how different is it from using a 'and' condition? Couldn't not find an answer for this in the user ...

Thank you @Mohan_Dugganab - this article only mentions that legacy APIs will be deprecated. Do you have the link to the documentation where it says the prefix will be updated from xcore to dps? 

We have created a few placements (in the same sandbox/environment) for the same channel (web) and same content type (text). But some placements have prefix: 'dps:offer-placement:' whereas some have 'xcore:offer-placement:' Can someone explain why the prefixes are different?@Mohan_Dugganab @Satheeska...

Federated Audience Composition was introduced during the latest Summit. This feature allows us to use the data that's in a warehouse (say for example) without bringing in into the Platform. The fundamental question is - doesn't the data need to be 'enabled to the Profile'? Can it be used without ena...

No, there were no long running queries at the time. We are pursuing this with Support. Thanks.

"This checks the first character to see if it is between 0 and 9. If it is then convert the value to an Integer. Otherwise put "-1" in the data."How to make this work for decimal values? Like 5.5 or 12.5?

NOTE: This is not the same issue as the 'Start Pending' that quite a few users have reported.  Campaign Classic v7 (hosted). At times, part of the delivery gets stuck in 'Pending' status. The (email) delivery kicks of as expected but not all the emails are sent out. For the once stuck in 'Pending' s...