Show Data dialog box

You can examine the underlying attribute and metric data within a visualization in a simple grid format, using the Show Data dialog box. You can:

Sort, pivot, and copy data in the grid
Save the data in the grid as a CSV file
Create a new Grid visualization using the data in the grid

For quick steps to view underlying data, see To view the underlying data in a visualization.

Adding, displaying, and deleting data views

You can create and display additional views of your data. For example, you can create a view that includes data from all attributes and metrics in the VI dashboard's dataset, regardless of whether the attributes and metrics are displayed in the visualization. Each view is displayed on a different tab at the top of the Show Data dialog box. You can click on a tab to switch to a specific data view.

When you examine the underlying data in a visualization, the My Data tab is automatically created and displayed in the Show Data dialog box. Depending on the data you chose to examine, this tab contains one of the following:

Data from all attributes and metrics that have been added to the visualization
Attribute and metric data for selected elements in the visualization only

To add a view of your data, click the Add icon displayed to the right of the tabs, then select one of the following:

All Objects: Select this option to create a view that includes data from all report objects in the VI dashboard's dataset.
To create a view that contains data from a specific attribute in addition to the attributes and metrics currently added to the visualization, select the name of the attribute to include in the view.

To delete an existing view, hover the cursor over the view's tab, then click X. You cannot delete the My Data tab.

Sorting, pivoting, and copying the underlying data in a visualization

The underlying data in the visualization is shown in grid format in the Show Data dialog box, with all attribute data displayed in columns in the grid, followed by all the metric data. You can sort and pivot data, resize columns, copy data rows in the grid, and so on.

To sort data in the grid, click the header of the column you want to sort by. The data is automatically sorted in ascending order (A to Z). Click the header again to sort in descending order (Z to A).
To move data in the grid, hover over the header of the data that you want to move, then click the arrow icon. Select Move Left to move the column one space to the left, or Move Right to move the column one space to the right.
To copy data rows in the grid, click on a row to select it. You can press CTRL and click specific rows to select them, or press SHIFT to select consecutive rows. Click the Copy to Clipboard icon to copy the data to the clipboard. You can then paste the copied rows into an application such as Word or Excel.
To resize columns, hover the cursor over the right edge of the column to resize, so that the cursor becomes horizontal arrows. Click and drag the edge of the column to resize it, or double-click the edge of the column to have the column automatically sized to fit its contents.

The following options are available:

Show All Metrics: Select this option to include data from all metrics on the currently displayed tab, including metrics that are included in the VI dashboard's dataset, but have not been added to the visualization.

Save Data Save Data icon : Select this option to save the data on the currently displayed tab in a comma-separated values (CSV) file. Browse to the location in which you want to save the file, then type a name for the file and click Save to save it.

Copy to Clipboard Copy to Clipboard icon : Select this option to copy selected data rows to the clipboard. You can then paste the copied rows into an application such as Word or Excel.

Add as Grid To Add As Grid To icon : Select this option to add the data on the currently displayed tab to the VI dashboard as a new Grid visualization. Do one of the following:

- To add the visualization to the currently displayed panel, select Current Panel.
- To add the visualization to a new panel, select New Panel.

To view the underlying data in a visualization using the Show Data dialog box:

Select the data to examine by doing one of the following:
- To display all the underlying attribute and metric data in a visualization, hover the cursor over the visualization. Click the arrow icon displayed in the top right, then select Show Data.
- To display underlying attribute and metric data only for selected elements in a visualization, select the elements that you want to examine. Click the arrow icon displayed in the top right, then select Show Data.
The Show Data dialog box opens, with a grid containing the underlying data in the visualization. Select the appropriate options to view, save, or add additional data to the dashboard, as described above. When finished, click Close to return to the VI dashboard.