# Splitting and grouping: charts

In this section, we'll discover the various options in Inforiver to split and group measures in Chart mode.

### 1. Splitting measures

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.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FNwT1MtfHl1b28CK7O0DI%2Fimage.png?alt=media&#x26;token=d9862337-cd85-42a2-a481-44ea68514373" alt=""><figcaption><p>Split option</p></figcaption></figure>

Notice how the Actuals and Plan for each year are rendered as a separate chart when splitting is enabled.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FWcYEOicxl9K9592r6sFk%2FSplittedhart.png?alt=media&#x26;token=a54ff41f-427e-4df9-b5b2-1768fe604730" alt=""><figcaption><p>Multi-measure chart split into multiple panels</p></figcaption></figure>

### 2. Measures category

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.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F00fPuolyOYrVPn2j60Py%2Fimage.png?alt=media&#x26;token=6c6e8e70-73c5-4e0a-87c8-631800d43d77" alt=""><figcaption><p>Measures category assigned to the row bucket</p></figcaption></figure>

The image below shows the measures rendered as columns.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FGDOqUqCjbu96dn8VbQ4V%2Fimage.png?alt=media&#x26;token=bd95f105-94b2-4ddb-bf5d-b305a4f066cb" alt=""><figcaption><p>Measures category assigned to the columns bucket</p></figcaption></figure>

You can also render measures as stacked charts by assigning the measures group to the legends bucket.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FMh7NDIqZR3jLR5ZqpCdi%2Fimage.png?alt=media&#x26;token=2a78663d-1cd4-41b6-a11c-e8cf845423cc" alt=""><figcaption><p>Measures category assigned to the legend bucket</p></figcaption></figure>

### 3. Grouping measures

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.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F50C03CnZk4SOxa5luedv%2Fimage.png?alt=media&#x26;token=9e83ce09-298a-4a24-956d-0762670a2fbb" alt=""><figcaption><p>Grouping measures</p></figcaption></figure>

Let's look at the steps involved in grouping measures.

**Step 1:**  Click on the Group Measure option, to create custom measure groups

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FW7PX4TYY07vymaufukUl%2Fimage.png?alt=media&#x26;token=3b3cdad7-4cbf-458c-b49f-792a991aa20d" alt=""><figcaption><p>Group measure option</p></figcaption></figure>

**Step 2:**  Click on the Add new group button.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FRN4HZaIsIaI8EKmJOXaw%2Fimage.png?alt=media&#x26;token=e3c22b05-16e2-429d-b836-460ac3cd61ba" alt=""><figcaption><p>Adding a new group</p></figcaption></figure>

**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.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FIo8jiFiKLe6CAB3SlQxP%2Fimage.png?alt=media&#x26;token=0a0bbcca-7779-4dc7-a0a5-cdc2c6650aff" alt=""><figcaption><p>Measures group created for 2024, 2023 and 2022 Actuals </p></figcaption></figure>

**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.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FHY537VFQZRMU257dUvhc%2Fimage.png?alt=media&#x26;token=57f220c8-2f53-45af-a24c-63f39c44fa51" alt=""><figcaption><p>Chart type changed to area after creating groups for Actuals and Plan</p></figcaption></figure>

### 4. Row and column groups

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.

{% hint style="info" %}

* 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.
  {% endhint %}

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FB7tYmaDIqS9bqcXUP3fB%2Fimage.png?alt=media&#x26;token=e8ff1b4c-89dc-494c-ad5a-7ec7f51a612a" alt=""><figcaption><p>Split applied on small multiples table</p></figcaption></figure>

#### 4.1. Creating a custom row group

1. 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.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2Fl4M2rkP2UhHOhzC7SnEn%2Fimage.png?alt=media&#x26;token=843949a9-fb64-40f8-a702-15586c9ab37f" alt=""><figcaption><p>Creating row groups</p></figcaption></figure>

Notice how the 2024 Actuals and Plan which were plotted as 2 different rows have been combined into a single row.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F4pTjZp6HPXBvrnJCEJv3%2Fimage.png?alt=media&#x26;token=130cb1b7-11c8-4d40-9c3b-4a2b4636a11e" alt=""><figcaption><p>Row group created for 2024 measures</p></figcaption></figure>

#### 4.2. Creating a column group

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.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FhMGeSeBUNUIMtHbJMS0x%2Fimage.png?alt=media&#x26;token=0d54ccb2-feaf-4980-b4c1-39ec43f59044" alt=""><figcaption><p>Creating a column group</p></figcaption></figure>

Notice how the APAC and EMEA subregions have been combined into a single column.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FzYk88jJjBgJjFJAzJjds%2Fimage.png?alt=media&#x26;token=5daf6d07-9c6e-4e71-a520-6fd200463a49" alt=""><figcaption><p>Column groups</p></figcaption></figure>
