Contents

How to Build a Table

To create a Table View, drag, at least, one Measure or Dimension into a Column or Row deck and choose [Table] from the Chart Properties Type dropdown. Tables display data in text format, much like a spreadsheet, allowing you to select individual cells or groups of cells via click and drag. Columns can be sorted by clicking column header sort icons, and their widths can be stretched or shrunk by grabbing column header edges and dragging.

If just one Dimension is placed in the Columns or Rows deck, Visual Analytics will default to showing the COUNT of that Dimension found in your Data Source.

If just one Measure is placed in the Columns or Rows deck, Visual Analytics will default to showing the SUM of that Measure found in your Data Source.

You can right-click on a Measure in the Columns or Rows deck and change its Measure Type from SUM to Average, Count, Minimum, Maximum, Standard Deviation, Variance, First or Last to change what displays as the default in the table for that measure.

As more Dimensions and Measures are placed in the Rows and Columns Decks, more data becomes visible. When multiple Dimensions are placed on a deck, the Table presents the left most Dimensions as a header, with Dimensions to the right of it as subcategories.

When a header within a table is left clicked, it sets the background of the header cell as dark blue and selects all of its underlying cells. Hovering over it produces a tooltip displaying details about its component cells. It is also possible to click the [View Data] icon in the tooltip to view both the data from the table as well as the underlying data from the Data Source.

See Viewing Data for more details on what's possible when viewing data.

 

It is also possible to drag across several cells within the table and see a tooltip that summarizes all of the data you have selected. Selected cells within the body of a table have a light blue background color while the other cells dim to make your selection stand out.

Export Table as HTML

It's possible to export the content of the currently viewed pivot as HTML by selecting [Worksheet] > [Export] > [Table...]

You can then choose a name and destination for your exported table's HTML file.

Your export can then be viewed in a web browser or emailed to others.

Following export to HTML, table header cells that are spanned over more than 1000 columns are not properly rendered in Firefox.
This is a known Firefox bug. Other browsers render appropriately.

Another limitation during export to HTML is with the Chrome Browser. Chrome has a rowspan limit of 8190.
This is a known Chrome bug. A similar bug with Firefox has been fixed and the export to HTML works correctly with rowspan, when opened with Firefox. Other browsers render correctly.

See the Table Calculations page for how to create and edit table calculations.

How to Build a Highlight Table

The Highlight table applies a background color to the table cells when you place a measure in the Color Deck. You can easily compare values in rows and columns because of the varying color shades.

Download and connect to the sample data source. We are making this chart using 3 dimensions and 1 measure.
There are two ways of building a Highlight Table. We are using the Visualization Palette. Another way is to build a table first and then from the Options Deck, choose Highlight Table.


To build a Highlight Table

  1. Connect to the sample data source in Aqua Data Studio.
  2. From the Dimensions pane, select Ship Method, Product Category, and Freight.
  3. From the Measures pane, select Profit.
  4. Click the tab and then click . Visualization builds a Highlight Table.

Visualization builds a Highlight Table and moves Ship Mode, Product Category, and Freight to the Rows Deck, and moves Profit to the Color Deck and applies a default color theme to the background cells of the Ship Mode rows. In the given example, we have moved Ship Method and Freight to the Columns Deck.

Copy Pivot Grid (Table only)

You can now copy a table chart in HTML format. Web applications such as Gmail and desktop applications such as Excel preserve highlighting and formatting when pasting data into these applications. The Copy Pivot Grid (Table only) command in Worksheets menu is enabled only for the Table chart. For all other charts, this command remains disabled.  
 
To copy pivot grid

  1. Create a table chart and add formatting to it. 
  2. On the Visual Analytics menu bar, click Worksheets > Copy Pivot Grid (Table only).
  3. Open a web application, such as Gmail or desktop applications, such as Excel and paste the pivot grid. Visual Analytics preserves the formatting of the pivot grid in the web application. 

Other Actions

Other actions that you can perform on a plotted table are as follows:

  • You can sort data by using various sort options available in the chart view or the Advanced dialog. For more information, see Sorting.
  • You can use highlight actions to focus on selected table cells. Visual Analytics makes the highlighted cells and its data labels prominent while dimming others in the view. For more information, see Highlight Actions.
  • You can filter records directly from the chart view without manually adding any fields to the Filters Deck. For more information, see Filters.
  • You can export worksheets containing visualization to Image, HTML, PDF, and Excel formats. For more information, see Export Visualizations.



  • No labels