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

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

You should be able to create measures like this:

 

Email Only = 
VAR tmpTable = SUMMARIZE(Table8,[ID],[Offer],"RL",MAX([Received Letter]),"RE",MAX([Received Email]),"RP",MAX([Received Phone Call]))
VAR RL = MAXX(tmpTable,[RL])
VAR RE = MAXX(tmpTable,[RE])
VAR RP = MAXX(tmpTable,[RP])
RETURN IF(RL="Y" && RE="N" && RP="N","Y","N")
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks very much for this Greg!  I have one quick question regarding the last piece

 

RETURN IF(RL="Y" && RE="N" && RP="N","Y","N") 

 

Does there always have to be 3 outcomes at the end (N,Y,N)?  Or can this simply be N?