How to Make 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's 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's 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.

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