Versions Compared

Old Version 5

changes.mady.by.user Wara Hermosa

Saved on

compared with

New Version Current

changes.mady.by.user Nadine Hinojosa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

Image Modified

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.

Image Modified

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

 Image Modified

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.

Image Modified

Export Table as HTML

...

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

Image Modified

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

...

Info

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.


Image Modified

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.
    Image Modified

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.

...

  1. Create a table chart and add formatting to it. 
  2. On the Visual Analytics menu bar, click Worksheets > Copy Pivot Grid (Table only).
    Image Modified
  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. 
    Image Modified

Other Actions

...