Data Binding Examples
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
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.
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.
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).
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.
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.
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).