I want to have a report scheduled to be sent via email, but unfortunately the data in the pdf report is not formatted as it is on the dashboard.
For example: $11,323,665 shows as 11323665 in the pdf.
I converted the dashboard to html, the html code contains the number formatting, but it doesn't show on the html dashboard.
Multiple dashboard panels have a table with one row, the row of data is displayed in very small characters, hard to read, and the numbers that are not formatted are even harder to read because they are displayed much smaller. How can I change the formatting on the pdf ?
I used this workaround:
I converted the numbers to a string and used the fieldformat command to add the commas.
Example:
| fieldformat DollarValue ="$ ".tostring(DollarValue,"commas")