Creating combination graphs

Combination graphs display a combination of different graph shapes in the same Graph visualization. For example, you can use combination graphs for stock volume graphs, which combine the line graph and bar graph. You can display a graph that contains sales statistics, with actual sales values displayed using bar risers and target sales values displayed as tick marks overlaid on top of the bars. Each metric in a combination graph can be displayed using a different shape. Steps to create and add a combination graph to a dashboard are provided below.

In the image above, multiple metrics are displayed in a single graph. You can also slice your data to display multiple rows or columns of graphs. For example, you can display each metric in a separate graph, and use a different graph shape for each metric. To do so, you slice the graph using the Metric Names attribute.

A combination graph can display the following graph shapes:

In a stacked combination graph, each metric is displayed in the graph in the order in which it appears in the Vertical or Horizontal area on the visualization’s Editor panel.

In an absolute combination graph, each metric is displayed in order according to the shape used to represent the metric’s values in the graph, as follows (shapes with higher priority are displayed at the top of the list):

If more than one metric is displayed using shapes with the same display priority, the order in which they appear in the Vertical or Horizontal area determines the order in which they are displayed.

You can convert an existing area, bar, or line graph into a combination graph by right-clicking the name of a metric in the graph, pointing to Change Shape, and selecting the type of shape to use to display metric values. For steps to create an area, bar, or line graph, see Creating area, bar, or line graphs.

Prerequisite

The steps below assume that you have already created the dashboard that you want to modify. For steps, see Creating a dashboard.

 

To create a combination graph

  1. Click the name of the dashboard to run it.

  2. From the toolbar, click the Insert Visualization icon . A new blank visualization is added to the dashboard and displayed.

  3. If the Visualization Gallery is not displayed, from the View menu, select Visualization Gallery.

  4. On the Visualization Gallery, select the Combo Chart icon.

  5. If the Datasets panel is not displayed, from the View menu, select Datasets Panel.

  6. If the Editor panel is not displayed, from the View menu, select Editor Panel. If the Editor panel is hidden behind another panel, click the Editor icon to display the Editor panel.

  7. Add data to the visualization. From the Datasets panel, click and drag objects to the Editor panel, as described in the steps below. You can also drag objects from the Datasets panel directly onto the visualizatio

Note: To view data requirements for a graph style, hover your cursor over the visualization icon in the Visualization Gallery. For example images for each graph style, see Minimum data requirements to create each Graph visualization style.

  1. To display values along the X-axis and Y-axis of the graph, perform the following steps:

  1. To display attribute elements on the X-axis, place at least one attribute in the Horizontal area.

  2. To display metric values on the Y-axis, place at least one metric in the Vertical area.

  1. To display metric values on the X-axis, place at least one metric in the Horizontal area.

  2. To display attribute elements on the Y-axis, place at least one attribute in the Vertical area.

  1. To color the items in the graph based on attributes or metrics, place objects on the Color By area, as follows:

  1. To display a separate graph item for each element in an attribute, place at least one attribute in the Break By area. For example, you can display the revenue data for each Region as a separate line, or display a bar riser for each year of data. If you add more than one attribute to the Break By area, a graph item is displayed for each combination of the attribute elements.

  2. For each attribute in the Editor panel, you can select which attribute forms are displayed in the visualization. An attribute form is a descriptive category for an attribute. For a more detailed description, including how to select what attribute information to display in the headers, see Selecting which attribute forms to display in a visualization.

To select the attribute forms:

  1. In the Editor panel, right-click the attribute and point to Display Attribute Form. Select one of the following:

  1. You can select which graph subtype to display in the visualization, or allow the subtype to be automatically chosen. Do one of the following:

  1. You can select which graph subtype to display in the visualization, or allow the subtype to be automatically chosen. Do one of the following:

  1. To size the graph items based on the value of a metric, place one metric in the Size By area. Graph items corresponding to large metric values are displayed as larger in size, while graph items for small metric values are displayed as smaller in size. For example, lines representing larger metric values are displayed as thicker than lines representing smaller metric values.

  2. Once you have added data to the visualization, you can choose to slice the data into rows and columns of separate graphs, based on attributes (including the Metric Names attribute). If you slice the data into both rows and columns, a table of graphs is displayed, with a graph for each combination of the attribute elements. Choose from the following:

  1. To display additional metrics in a tooltip when you hover the cursor over a graph item, place the metrics that you want to display on the Tooltip area.

  2. To change the shape used to display a metric in the graph, right-click the name of the metric in the Editor panel. You can also select the name of the metric in the graph. Point to Change Shape, then select the shape to use to display the metric. Repeat this step as necessary to define the shape to use to display each metric in the graph.

  3. Click the Save icon to save your changes.

Related topics

Creating a Graph visualization

Minimum data requirements to create each Graph visualization style

Creating area, bar, or line graphs

Creating bubble or scatter graphs

Creating a graph with graph markers displayed in a grid layout

Creating pie or ring graphs

Creating dual-axis graphs

 

 

_____________________________