Cross Tabbing

A Cross Tab is the division of a single visualization into smaller multiple visualizations across either on rows, columns or both. Each smaller child visualization displays the relevant portion of the data set. It can also be called trellising, or small multiples.

The purpose of a cross tab is to allow comparison across portions of the data set.

Cross tabbing is available in the following visualizations:

q  Bar Graph q  Box Plot q  Bullet Graph q  Candlestick q  Categorical Line Graph q  Circle Pack q  Donut Chart q  Donut Gauge q  Dot Plot q  Funnel Chart q  Grouped Needle Graph q  Heat Matrix q  Line Graph q  Needle Graph q  Numeric Needle Graph q  Numeric Line Graph

q  Numeric Stacked Needle q  OHLC Graph q  Order Book q  Pareto Chart q  Pie Chart q  Price Band q  Scatter Plot q  Spread Graph q  Stacked Needle Graph q  Stack Graph q  Ticker Tile q  Treemap q  Timeseries Combination q  Timeseries Scatter Plot q  Waterfall Chart

Steps:

1.     Select a visualization that supports cross tabbing like a Bar Graph.

2.     You can either:

·         drag text columns into the Rows or Columns drop areas on the Visualization pane

 

·         or select from the Rows or Columns buttons on the visualization

This example is selecting from the Columns  button.

 

Once dropped, the visualization will be cross tabbed, producing a series of smaller visualizations for each item within the column dropped.

On both instances, the new column is added under the Breakdown tab and on the visualization.

 

Cross tabs can be across rows, across columns, or across both where two separate cross tabbing dimensions have been selected.

Dropping a text column onto the Columns section trellis the visualization horizontally:

While dropping a column onto the Rows section trellis the visualization vertically:

And finally dropping columns onto both Rows and Columns produces a series of smaller trellised visuals. Each showing the specified subset of the overall dataset.