Customer Journey Analytics - Creating A Filter From Array Data

[jm_11]

Use Case: We have the following use case, we have an array of objects in AEP as part of a profile schema. Each object contains the following attribute:

1. Status -> can have values: Active or Pend or Cancelled
2. Indicator 1: Boolean
3. Indicator 2: Boolean
4. Some Other attributes

 So to conceptualize, our data would look something like this within AEP for the array of objects in the details array for a given profile.

Sample data:
details : [

{ Status: Active, Indicator 1: true, Indicator 2: false …},

{ Status: Pend, Indicator 1: false, Indicator 2: true …},

{ Status: Cancelled, Indicator 1: true, Indicator 2: false …}

]

We want to create a filter to capture all profiles in our CJA dashboard that have an object in the array where all the following conditions are met:
1. Status = Active

2. Indicator 1 = True

That is the general use case.

When we create a calculated filter with these conditions, the filter picks up profiles who in some object have Status set to Active and in some object have Indicator 1 set to True.

But we want this filter to pick up only profiles, that have those conditions being met in the same object.

[Josh__Stephens · Accepted solution]

I found this link that looks like it might be helpful.