How to change number and date formats for XML and CSV reports/export

Format information:
The number and date value formats of export /report changed for the file types CSV and XML. The new format is the same as when you view the data on the website or in the PDF file.

Some of the changed effects:

  • Number columns - Rounded values to fewer digits (100,456789 => 100,5)
  • Number columns - Added thousands separator (1000 => 1.000)
  • Date columns - Only shows date and not date and time together

How to change the format:
Now  you can customize the format for dates and numbers for each column, just as you would change the column header. Follow these steps to change the format for easy integration with your systems

  1. Locate your desired view in Reports > Overview
  2. Choose to edit the Report
  3. Then select the Pencil icon for the desired column to change
  4. Choose the format your system prefers 

 Ex. Changing format

 

Unable to edit or change a Report?
You will notice some of the reports on the Reports > Overview page are not editable. If you need one of these reports edited, first you need to duplicate the report of your choice. After duplicating the report, you have full control of the report and can control who has access to using it; either for your account only or for all of the child accounts under your parent account.