Page History
The View Data window displays summarized or underlying data of a dataset or data of a view.
Contents
| Table of Contents |
|---|
Underlying Data of the Dataset
In the Data Pane, when you click , Visual Analytics opens the View Data window that contains the underlying data of your dataset.
...
The Show All fields check box, when selected, shows the underlying data for all dimensions and measures in the data pane for the highlighted data points. When you clear this check box, only the underlying data of the dimensions or measures using which you had built the chart is displayed.
In the following example, after clearing the check box, the underlying data for Card Type and Profit is displayed. In addition, we have highlighted ColonialVoice, Distinguish, and SuperiorCard data points in the chart view, therefore, Visual Analytics shows the underlying data only for these data points.
View Data Window
The View Data window supports quick filtering, aggregate functions, and multicolumn sorting. Aggregate Functions allows calculation of Count, Count Numbers, Sum, Min, Max, Average, and Standard Deviation functions on the rows that you select in the View Data window.
...
Another option that is available in the View Data window is Preview in Excel () that exports the data to an Excel spreadsheet. Additional options appear on clicking the arrow that is available next to the icon.
| Info |
|---|
Aggregate Functions, Quick Filtering, or Multi-Column sorting performed in the View Data window do not affect Visual Analytics Charts or Tables. |
Right-Click Options in View Data Window
The following table lists the right-click options in the View Data Window.
| Options available on right-click | Description |
|---|---|
Select All (CTRL/Command+A) | Select all columns and rows. |
| Copy (CTRL/Command+C) | Copy selected columns or rows. |
| Shows additional options when you point to this option. | |
| Opens the Copy to Clipboard dialog. |
Copy Special
Copy Special is a right-click option and shows additional options when you point to this option. The following table lists its additional options.
| Option | Description |
|---|---|
Copy With Headers | By default, Visual Analytics copies data without the column headers. This option copies the headers, along with the data. |
| Copy with Row Count | Copies the row count, along with the data. |
| Copy with Headers and Row Count | Copies column headers and row counts, along with data. |
| Copy Headers Only | Copies only column headers. |
| Copy with Headers (Align Columns) | Copies column headers and data and retains the column alignment in the destination file. See Attachment. |
| Copy with Row Count (Align Columns) | Copies row counts and data and retains the column alignment in the destination file. See Attachment. |
| Copy with Headers and Row Count (Align Columns) | Copies column headers, row counts, and data and retains the column alignment in the destination file. See Attachment. |
Copy As
Copy As is a right-click option and opens the Copy to Clipboard dialog. The following table lists the options in the Copy to Clipboard dialog.
| Option | Description |
|---|---|
| Data Order | Retains the data presentation for horizontal data order. In Vertical data order, displays columns as rows and rows as columns. |
| Separator | Adds a separator between 2 cell values. |
| Quote Identifier | Adds quotes across cell value. |
| Leading Enclosure | Inserts user-specified characters at the start of copied data. |
| Trailing Enclosure | Insert user-specified characters at the end of copied data. |
| One line per table row | Inserts complete data in one line. |
| Wrap Line at Column | Wraps line at a user-specified value and then displays data in the next row. |
See Also
...