I have a TimedDataPoint table containing numerical values (such as voltage) stored as double with @ts(treatment=‘rate’), and string values (such as color?) stored as ‘RED’ / ‘BLUE’.
The normalization of numerical values is well understood. How does the platform handle the normalization of string values?
Can I create a metric like this
"avg(avg(normalized.data.color == 'RED'))"?