I have some measures in my model which are defined using the `value_format: "0.00\%"`
and then used the sql definition as opposed to `measure type`, example:
measure: CTR {
group_label: "Cost_Performance_Info"
value_format: "0.00\%"
sql:case when sum(impressions)=0 then 0 else sum(clicks)/sum(impressions) end;;
}
When using the Table with Subtotal visualization I get an error that measures with string format are not allowed, how can I bypass this error?