I’d like to include some filters on my dashboard.
Is there a way to map a value to a display name on controls?
i.e.
0: “Missed SLA”,
1: “Met SLA”
I’m aware I can create another column with an ifelse but that duplicates the data.
Does anyone know a better way of doing this?
Hello @Ted,
As of now, this is not possible natively in QuickSight.
If you are worried about having the data duplicated in the dashboard you could just create the calculation on the dataset and then hide the column with the boolean, in this way there will be only one column with the value available.
Another option could be, if the data is on a database that support case statements, write a custom sql to transform the boolean for the Missed/Met string.
I will mark your original question as a feature request, if any of the solutions I mentioned work for you as a workarround, please mark this answer as a solution.
Hope this help!
Kind Regards,
Andres.
Thanks Andres,
This doesn’t solve my issue as I still need the value for a ratio of met KPI.
I appreciate your support