Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Flag based on value on multiple rows

Hi,   I have a data set that contains a unique value for each customer as well as a column which indicates what offer they received as well as the method of communication (channel).  For example; ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Like this? See last row, a duplicate of the first row with a Y added to Email

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

What happens in your example if you duplicate your first row, but add a Y to the letter or phone call?  do you get the same answer in your calculated column?

 

Many thanks

Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

Anonymous

 

Hi, You can try doing this in Query Editor.

 

1. Group By ID & Offer

And Aggregation MAX of every Column (Letter, Email and PhoneCall)

 

2. Create custom Columns using "and " operator to evaluate the conditions.

 

Regards

 

Victor

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Greg, you're a star.  Everything works perfectly now (I've also added the extra column to filter by).

     

    Appreciate your help!!

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    Like this? See last row, a duplicate of the first row with a Y added to Email

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Greg,

     

    Yours looks exactly how I want it. and even though i've replicated what you've got, I can't get the right outcome.  This is very strange!

     

     

     

    Many thanks

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    You have 2 OB's in your IF statement. One of them needs to be DM. Also, I would use ALL and not ALLSELECTED. Finally, ou have another column which you might need to filter on but I wouldn't worry about that until the other 2 issues are addressed.