Knowledge Drop
Last Tested: Jan 21, 2019
This can happen if you are applying a Default Format option or a value_format OR value_format_name on your Table Calculation or LookML fields, respectively. For example:
Table Calculation Expression
${products.count}/sum(${products.count})
This will typically produce a value on the scale of 0.0 to 1.0, where 0.75 represents 75%. In the UI you can apply a format option from the format dropdown like “Percent( 1 ) – 123,456.7%” to always show 75%. However any conditional format rules still need to apply to values in the 0.0 to 1.0 range.
Measure / LookML Field
measure: percent_calc {
type: number
sql: ${order_amount} / ${sum_all_orders} ;;
value_format_name: percent_1
}
This is a similar scenario as above. The values in the Explore table will show full ##.#% values, but any calculations or conditional formats will need to apply to the raw value range, typically 0.0 to 1.0 when working with percents.