I’m trying to create a dashboard to track an operational workflow.
I want to know if a question called is_supporting is: True / False / NULL.
Null would indicate to me that the question hasn’t been answered by a staff member. However - the null values are all showing up as “0”, make it difficult to discern where the question was answered as “FALSE” or whether the question hasn’t been answered.
Changing it from a measure to dimension type did not help
Creating a calculated field like - ifelse(isNull({IS_SUPPORTING), “No response”, {IS_SUPPORTING} = 1, “Yes”, “No”) also didn’t work; still seeing "No"s for everything.
Thank you for asking QuickSight question in this community. Could you tell me the data type in field of is_supporting? Or the data type specified for the calculated field. Thanks.
hi @Xing, I am experiencing the same issue. The data on my DB side is TRUE/FALSE/NULL, when importing it into a Quicksight dataset, the fields get mapped to a numeric type {TRUE: 1, FALSE: 0, NULL: 0}. Is there away to set this mapping to preserve the NULL values instead of mapping them to 0 at the dataset level without having to change the underlying data coming from the DB?
FYI: I don’t mind if the boolean fields get mapped to a 1/0 numerical type if booleans are not natively supported, but NULLs getting mapped to 0 as well presents a big problem for my analyses.