I know we could use 0/1 but the whole appeal of the yesno fields in Looker is that they are automatically labelled nicely like that. I would like to be able to format them conditionally.
This would require conditional formatting to allow non-numeric fields, which I think would be great in general, even if to highlight specific words etc.
Hi @Dawid Currently Looker conditional formatting only works with numeric fields, so yesno dimensions and most table calculations cannot be used directly. That is why 0 and 1 works, but Yes and No does not.
If you want to keep the Yes/No labels, a common workaround is to create a numeric field for formatting purposes and keep the yesno field for display. For example, create a hidden 0/1 dimension or table calculation and apply conditional formatting based on that field, while still showing the Yes/No column in the table.
Another option is to create a custom dimension that returns text but is driven by a numeric logic field used only for formatting.
At the moment, allowing non numeric fields in conditional formatting would require a product enhancement. If this is important for your use case, it should be submitted as a feature request through the official Looker Idea portal.
Yes I know how it works.. hence this is more of a feature request type of post : ) I went through all the workarounds and they don’t satisfy me…