Splitting and grouping: charts
Last updated
Last updated
In this section, we'll discover the various options in Inforiver to split and group measures in Chart mode.
When you have multiple measures in your chart, you can display each measure in a separate panel. Click on the Split button in the toolbar to split charts.
Notice how the Actuals and Plan for each year are rendered as a separate chart when splitting is enabled.
When the split option is enabled a measures category is created: the measures can be rendered as rows/columns/legends. Note: we have added Sub Category as a small multiples parameter to demonstrate this.
The image below shows the measures rendered as columns.
You can also render measures as stacked charts by assigning the measures group to the legends bucket.
With Inforiver, you can combine measures into a single pane and create custom groups. Notice how the Actuals and Plan for each year have been combined into 3 distinct panes corresponding to 3 years. Note: in this example, the chart type was changed to a combo chart after grouping.
Let's look at the steps involved in grouping measures.
Step 1: Click on the Group Measure option, to create custom measure groups
Step 2: Click on the Add new group button.
Step 3: Select related measures to create a group. You can provide a relevant name for the group in the Title textbox. When you click Apply, the selected measures are combined into a single panel.
Step 4: Notice that a line chart is rendered for the group. You can customize the chart type for each panel after creating groups. In the example, we've created 2 measure groups for Actuals and Plan and changed the chart type to area.
In small multiples mode, you can create groups for dimensions or measures. To demonstrate this, let's add SubRegion as a small multiples parameter and split the chart. The resulting trellis is depicted in the image below. Notice that the measures are plotted as rows and dimension categories are plotted as columns.
Grouping dimensions can be used only in matrix mode i.e. when the dimensions are plotted either as rows or columns, not both.
At a time, you can either create row groups or column groups.
In Matrix mode, the Group Measure side pane has an additional Bucket option. Let's create a row group for the 2024 Actuals and 2024 Plan measures.
Notice how the 2024 Actuals and Plan which were plotted as 2 different rows have been combined into a single row.
Let's create a custom group for the dimensions in the columns. When we select the Column option from the Bucket dropdown, the dimension categories are displayed in the side pane.
Notice how the APAC and EMEA subregions have been combined into a single column.
