I have a chart and would like to create a calculated dimension as follow where the values are:
Names are different ( when Name_1 <> Name_2)
Phones are different ( when Phone_1 <> Phone_2)
Mails are different ( when Mail_1 <> Mail_2)
If I do it with if and else as follow :
IF ( Name_1 <> Name_2 ,
'Names are different',
IF( Phone_1 <> Phone_2,
'Phones are different',
IF( Mail_1 <> Mail_2,
'Mails are different',
'-'
)
)
)
I will have in the line of the 'Phones are different' only the records where the name is equal and phone different - since this condition comes in the else.
And that's not what I want. I want the conditions to be independent one from other.
You can't do this in one dimension. Perhaps you can create flag fields in the script. In a chart you can then use expressions to count the records independently.
