How to remove comma’s from CSV dashboard report?

240 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?

Simon Mestdagh [SLC] [DevOps Advocate] Answered question 25th November 2024

3 Answers

1
74 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.

Simon Mestdagh [SLC] [DevOps Advocate] Answered question 25th November 2024
You are viewing 1 out of 3 answers, click here to view all answers.