View the original community article here
Last tested: Sep 11, 2019
Double check to see if the Yes and No values have quotes wrapped around them!
Note that if(${field_name} > x, "Yes", "No")
is not the same as if(${field_name} > x, yes, no)
. If we include quotes around the yes and no values, Looker will output strings and we'll lose the ability to select Hide No's From Visualization:
See how the option doesn't populate in the table calc settings? Now when we remove the quotes and use raw yesno values:
Take note of the purple/pink values! It's how you know you're doing it right.
This content is subject to limited support.