View the original community article here
Last tested: Apr 15, 2018
Yes, you can use the following syntax to conditionally format using value_format. This can be done in LookML OR it can be done in the EDIT menu in the Visualization. Note there are extra \ characters in the LookML version to help escape use of " characters.
Warning: value_format only takes three different conditions for evaluation. If you add a fourth it will not evaluate properly.
LookML Use
measure: count {
type: count
value_format: "[<1000]0;[>=1000000]0.00,,\"M\";[>=1000]0.0,\"K\""
}
EDIT UI Menu Use
Value Format (UI field):
[<1000]0;[>=1000000]0.00,,"M";[>=1000]0.0,"K"
For more tips on common value_formats, you can refer to this Docs page here.
This content is subject to limited support.