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

What if it looked like this for ID 1?

 

     Based on ID & Offer
IDOfferReceived LetterReceived EmailReceived Phone CallLetter OnlyEmail OnlyPhone Call OnlyLetter & Phone CallLetter & EmailEmail & Phone Call
120% offYNYNNNYNN
           
           
           
           
           
           
           
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi,

     

    that would be perfect. Any suggestions would be much appreciated.

     

    Thanks

    • 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?