Contents of the Calculated Fields Options Dialog Box

Use the dialog box to select and set options for adding your own calculated fields to the report.

Contents

Field Description
Click this option to display the dialog box in full screen.
Click this icon to export all the core data from the grid into a .CSV (comma-separated values) file that you save in Microsoft Excel or another spreadsheet application that supports .CSV files. You can modify the contents of the file (filter the data, format the contents, and so on) to produce useful reports and analysis. For more information see Exporting Data to a .CSV File.
Click this option to display the search field for the Available Calculation column. Use the search fields to narrow down the list of information in the columns.
Available Calculation This column displays calculation fields that are available in the dashpart. Click at the right side of each line item to display a menu with the following options:
  • Edit: Select this option to edit the corresponding calculated field. Click this option to display the Calculated Field dialog box, where you can find the calculation settings for the corresponding line item.
  • Copy: Select this option to copy the corresponding calculated field. Click this option to display the Calculated Field dialog box, where you can find the calculation settings for the corresponding line item; the Description field is appended with the "copy" label.
  • Delete: Select this option to delete the corresponding calculated field. Deleting a calculated field removes the calculated field from the dashpart base with which it is associated and removes the calculated field from any dashpart that already uses it.
+ New Calculation Select this option to create a new calculation field. When you click this option, the Calculated Fields dialog box displays, on which you configure the calculated field.
Select After you select a calculated field from the list of available calculation, click this option to add the selected calculated fields to the dashpart.
Cancel Click this option to close the dialog box.