Tips for Exporting

Here are some tips on exporting data from analyses, dashboards, and dashboard pages.

  • If you're exporting data with over one million rows, ask your administrator about the maximum number you're allowed to export.

  • By default, the Value Suppression option in the Column Properties dialog:Column Format tab determines if the cells in tables or pivot tables that span rows and cells that span columns are repeated when exporting to Excel (rather than always repeated). Don’t suppress values when exporting to Excel if those who use the Excel spreadsheets want to manipulate the data.

    • If Value Suppression is set to Suppress, then cells that span rows and cells that span columns aren’t repeated. For example, in a table that has Year and Month values, Year is displayed only once for Month values. This value suppression is useful if you want to simply view data in Excel spreadsheets.

    • If Value Suppression is set to Repeat, then cells that span rows and cells that span columns are repeated. For example, in a table that has Year and Month values, Year is repeated for all Month values.

  • In PDF format, rows are split across page breaks rather than kept together.

  • Action links aren’t included in exported formats.

  • When exporting to Excel, numbers and dates are exported in raw format with full number precision and format mask, rather than as a string in the data format specified.

  • When exporting analysis results to formatted Excel spreadsheets, you can choose whether to export full precision values or export abbreviated values that display in a performance tile. In the Performance Tile Properties dialog, select the Abbreviate Values option, which determines the level of abbreviation used in the performance tile, that is, thousands, millions, and so on. To export abbreviated values to Excel, select the Abbreviate in formatted Excel option.

  • While you can export directly to an Excel format, you might notice better performance during the export of large numbers of rows if you export first to CSV, and then import that file into Excel.