To export a dashboard item as a Microsoft Excel spreadsheet or CSV file:
-
Click the Export To button in the title of the dashboard item you want to export:
Note:
The Export To action is not available for filter items.
-
Select Export To Excel. The Export To Excel dialog box is displayed.
- Select a file format from the Excel Format drop-down list.
-
If CSV is selected as the format, enter the separator character to use in the Separator field. The default character is a comma ( , ).
Note:
The Separator field is only enabled if CSV is the selected format.
- Select Filters to include the filters applied to the data item in the spreadsheet.
- Select Parameters to include the parameters applied to the data item in the spreadsheet.
-
If Filters or Parameters is selected, select where in the spreadsheet to put the information from the Position drop-down list.
Note:
The Position drop-down list is only enabled if Filter or Parameters is selected.
- Click Export. The Save As dialog box is displayed.
- Select the location to save the file.
-
Type a file name in the field provided. By default, the Title value is used as the file name.
Note:
Titles may contain characters that are not allowed in file names, such as *. Remove any illegal file name characters before trying to save the exported item.
-
Click Save.
Note:
Graphical representations of the data, such as pie charts and bar charts, are not preserved. Data is saved to Excel in grid format for all data items.