Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What is the expected output here?
In these case Survey2 also should be shown as a dimension because fulfill the condition.
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
Hi Sara,
the first condition is always fulfilled.
Change order of If(then,else)
Regards,
Antonio