Hi Team,
In my data compliance’s value contains “Yes” and “No”. But in Viz I want to show “Compliance” and “Non-Compliance”. Is it possible in Quick Sight?
Please help me.
Thanks, in advanced
Regards,
Chaitanyakumar N
you can add a calculated field and use ifElse condition to show “Compliance” if the field value equals to “Y”. Then use the calculated field in the visual
Hi Royyung,
Thanks for your answer,
I am writing a calculation field like this:
ifelse({metric_category}=‘Yes’,‘Compliance’,{metric_category}=‘No’,‘Non-Compliance’)
but it is giving error, so please help me to write correct calculation please
Regards,
Chaitanyakumar N
You’re missing your final argument, try this.
ifelse({metric_category}=‘Yes’,‘Compliance’,{metric_category}=‘No’,‘Non-Compliance’, NULL)
Yes, I am missing Argument, thank you for your help and answer.