Conditional function that fulfill more than one condition

[Anonymous]

Hi,

I have a conditional function as a dimension:

Type=

=aggr(

if(sum({<Question={'A','B'}>}             Answer)  >2, 'Survey1',

if(sum({<Question={'A','B','C','D'}>}   Answer)  >5, 'Survey2',

if(sum({<Question={'H'}>}                  Answer)  <3, 'Survey3')))

, Name)

Tha data is:

If more than one condition is fulfilled, it just appear the first one.

How it can show all the values?

Thank you

[sunny_talwar]

What is the expected output here?

[Anonymous]

In these case Survey2 also should be shown as a dimension because fulfill the condition.

[miguelbraga]

Hey there,

Have you tried this?

=aggr(

          if(sum({<Question={'A','B'}>}             Answer)  >2, 'Survey1',

               if(sum({<Question={'A','B','C','D'}>}   Answer)  >5, 'Survey2',

                    if(sum({<Question={'H'}>}                  Answer)  <3, 'Survey3')

               )

          )

, Name, Question

)

Best regards,

Data Architect MB

[antoniotiman]

Hi Sara,

the first condition is always fulfilled.

Change order of If(then,else)

Regards,

Antonio