Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
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.
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
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.