Data Binding Examples

Contents[Hide]

1. Overview

This article gives specific examples of how to configure bindings for various types of data visualization controls. Bindings are mappings between parts of a data visualization and data elements from its underlying metric set. Using the Data Binding Panel and simple drag-and-drop operations, bindings can be easily configured to display data in your control in the form of labels, headers, and tooltips.

See Introduction to Data Binding to learn more about bindings.

2. Chart bindings

2.1. Clustering values in a bar chart

Binding a hierarchy to the SERIES 1 binding SERIES GROUPING will cluster a set of bars 

As an example, consider a chart with the following metric set configuration:

  • MEASURES: OrderQty
  • ROWS: OrderDate hierarchy

Bar chart showing OrderQty measure and OrderDate hierarchy
Bar chart showing OrderQty measure and OrderDate hierarchy

Click the Bindings button in the top-right corner of the Data Binding Panel to switch to the Bindings tab. Scroll down to locate the SERIES 1 binding LABEL TEXT and SERIES 1 binding SERIES GROUPING bindings. Go to the Explore window and drag a Product hierarchy to both bindings in turn. The resulting bar chart shows a cluster of data points for each year, and has a bar for each value in the top level of the Product hierarchy.

Using bindings to set up a clustered bar chart
Using bindings to set up a clustered bar chart

2.2. Axis Labels

Axis label bindings can be used to display grouping labels from upper levels of a hierarchy (e.g., Month grouping labels under Day labels) by dragging a hierarchy level from the Explore window, or to display measure values by dragging a measure.

2.3. Series Color

Series color bindings can be used to apply different colors to data points or series based on hierarchy values. Adding a series color binding activates color rules which you can configure from the Properties window. See Apply colors to data points or series using color rules for more details.

3. Table bindings

As an example of bindings for a table visualization, consider the following metric set which is configured as follows:

  • MEASURES: OrderQty, LineTotal
  • ROWS: OrderDate hierarchy
  • COLUMNS: Product hierarchy

Despite terminology such as COLUMNS and ROWS, the metric set configuration is not specific to a table visualization. Rather, these metric set terms are describing an overall multidimensional model which may be visualized using different data visualization types including charts and tables. The figure below shows how this metric set is configured in the Data Binding Panel along with the corresponding table visualization.

Metric Set tab in the Data Binding Panel for a table visualization
Metric Set tab in the Data Binding Panel for a table visualization

Click the Bindings button in the top-right corner of the Data Binding Panel to see the mappings of table elements to metric set elements (measures and hierarchies). In this case, bindings such as COLUMN HEADER, ROW HEADER, and COLUMNS actually do refer to specific parts of a table visualization. For this particular example, these parts are mapped as follows in the Bindings tab:

  • COLUMN HEADER - Maps to the Product hierarchy which is displayed as a row of table column headers above the table columns.
  • ROW HEADER - Maps to the OrderDate hierarchy which is displayed as a column of table row headers positioned to the left of the table columns. Row headers are a special kind of column designed to visually group data appearing on the right, where cells with the same row hierarchy value are merged. Expanders are used in row headers to present more detailed results consisting of cell values corresponding to lower hierarchy levels.
  • COLUMN - Maps to the OrderQty and LineTotal measures, each of which is displayed in its own table column. These two columns are repeated for each column hierarchy value (e.g., each Product hierarchy value).

Bindings tab showing mapping of table elements to metric set elements
Bindings tab showing mapping of table elements to metric set elements

In the above example, table columns are mapped to measures but you can also add row hierarchies to this binding in order to display a column of row hierarchy values.

The COLUMN binding maps to measures and row hierarchies
The COLUMN binding maps to measures and row hierarchies

Each table column has settings such as header text, tooltip, appearance, state styles, and different column types, all of which you can further customize via the Properties window.

Each table column has properties which you can customize
Each table column has properties which you can customize

When you're setting up interactivity such as hover-over interactions, you also have the option of targeting a specific table column (e.g., using the Bound visual option).

Tip
Click Bind data to columns in the Properties window to open the Data Binding Panel and go directly to the Bindings tab.

4. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri