refactor metrics_column_type to set column types on metrics assignment

also it parses _percentage metric names to guess type float