Support percents that are not multiplied by 100.

[reify-thomas-smith]

Generally, I want to handle formatting in the front-end code, not in Cube. For instance, if I want to display a number as a percentage in a table, then Cube will provide a ratio measure, and I'll turn it into a percentage string in the table column definition using Intl.NumberFormat. In particular, I expect Cube to provide a raw ratio, not a ratio multiplied by 100. This is consistent with the behavior of both Intl.NumberFormat and Excel, which will both turn .1 into 10% and 10 into 1000%.

However, Cube's percent formatter will format .1 as 0.10% rather than as 10%. This causes incorrect values to be displayed in the playground.

Describe the solution you'd like

Either a new format (e.g. percentNormalized) or a configuration option indicating that percent members are not multiplied by 100.

[github-actions[bot]]

If you are interested in working on this issue, please leave a comment below and we will be happy to assign the issue to you. If this is the first time you are contributing a Pull Request to Cube.js, please check our contribution guidelines. You can also post any questions while contributing in the #contributors channel in the Cube.js Slack.

[PieterVanZyl-Dev]

@reify-thomas-smith This is an interesting one

I'll investigate adding a new format, specifically for this, but what my previous company did to work around this. (We also had percentages in decimals)

Is in the cube configuration for this specific metric

percent: { sql: 100.0 * ${percentInDecimal}, type: number, format: percent, },

Just multiple your value by 100 in the sql, you only have to do this once and it will look the same on the frontend.