Hello everyone,
I have a calculated field in Quicksight which, based on the value of a parameter, takes a value which either a percentage or a number:
ifelse(${PercentageorNot} = ‘Percentage’, {value in %}, sum(value))
When I insert this field into my visualization, I can’t find a way to change dynamically between the option of showing as number and showing as percentage. Is there a way to do so?