How to remove comma’s from CSV dashboard report?

Solved685 viewsCSV Dashboard email
3
0 Comments

Hello Dojo,

I have a scheduler task to send out an email of a Dashboard report with the CSV option enabled. There are values in the table that have values greater than 1000. Those values, when viewed in Excel, are being interpreted as decimal values, so 12,345 is showing up as 12 because the decimal part is being removed.

So is there a configuration that can be done to remove the comma from the CSV export?

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 1 day ago

3 Answers

1
84 0 Comments

Hi Gabriel,

The CSV report sent with the email includes the display values rather than the raw data. To address the issue with numeric formatting (e.g., commas in values like 12,345 being misinterpreted), you can modify the display format of the values.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 1 day ago
You are viewing 1 out of 3 answers, click here to view all answers.