Expand my Community achievements bar.

Customer Journey Analytics - Creating A Filter From Array Data

Avatar

Level 2

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.

 

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Community Advisor

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