Hello GD team, is it expected for a metric in format percent (rounded) to appear as "0" and "1" instead of "0%" and "100%" (as it shows on the live report) when the report is exported as CSV (raw) or CSV (formatted)? Also, that the Avg row in the formatted csv will show as 0.654 instead of 65%? Is there anything we can do to prevent this? Metric is: SELECT IFNULL( (SELECT COUNT({label/tasks.id}) WHERE {label/tasks.completed} = "true"), 0 ) / (SELECT COUNT({label/tasks.id})) Format: Percent (rounded)

Hi Raffaella, I am happy to help. Can you please share the direct link of insight or metric with us to investigate further. Feel free to use DM.

Hi Mauricio, thanks. I have shared the link via DM

Hello Raffaella, Yes this is actually expected. A CSV is just a plain-text list of values, with no concept of “cell formatting.” Any “%” you see in a spreadsheet is coming from the application’s display settings, not the CSV itself. • CSV exports always emit the raw numbers (e.g.

0

,

1

,

0.654

). • XLSX exports carry along both the underlying values and the percent‐formatting metadata, so you see “0%”, “100%” and “65%” when you open it in Excel. So a logical option here would be to go with XLSX exports.

Hi @Julius Kos thanks for this. What is the difference then between CSV (raw) and CSV (formatted) export options?

Hi Raffaella, the formatted CSV is the standard one, and the raw one is an additional feature meant for too big tabular vizualisations. For example if there would be an tabular vizualisation exceeding our limits, instead of displaying too many data points (and if we are still in some reasonable limits) - you would be able to export it in raw format.