Create field that contains all combinations of two fields

[shtewari]

Hi all, 

I am trying to build a visualization which requires a combination of few fields. The detailed information is provided below.

User Dissatisfied (if any combination from below TRUE):-

-Average to low Classification  (Field 1)

-Falls in Class A and Class B (Field 2)

-Salary in average to low category (Field 3)

-Read Count less than 15000 (Field 4)

I am having all the above field values but am not able to get the combination of them. Like any two or more conditions are true then the used is dissatisfied.

Similarly I'm having few conditions for user satisfaction and for them also if any two or more conditions are true then the user is satisfied.

I cannot provide any qvf or dataset because it is confidential

Thank you for any help!

[Zhandos_Shotan]

Hi

Use 1 and 0 value for fields that indicate (1) dissatisfied conditions

Then check (Field 1 + Field 2 + Field 3 + Field 4)  > = 1

Regards

[Pawlak3B]

A data frame containing one row for each combination of the supplied factors. The first factors vary fastest TellPopeyes.

[ChiragPradhan]

Hi

See attached app. 

If it is what you are looking for, consider marking it as resolved.

[Chanty4u]

Hi you can try this 

=If(

    ((Field1 = 'Average to low' OR Field1 = 'Low') AND (Field2 = 'Class A' OR Field2 = 'Class B') AND Field3 <= 50000 AND Field4 < 15000),

    'Dissatisfied',

    'Satisfied

'

)

[Kushal_Chawda]

@shtewari  what are the sample values in all these fields especially for field1 & field2? Are these really a fields in table or calculated measures?