> For the complete documentation index, see [llms.txt](https://docs.inforiver.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.inforiver.com/infobridge-wb-matrix-only/9.-data-transformations/group-by.md). # Group by Learn how to aggregate and summarize detailed reports with the Group by transformation. ## Using the Group by transformation to aggregate your data We often need to summarize our data to identify metrics like the 'Total number of customers by region' or the 'Average sales per quarter'. You can use the Group by transformation to aggregate measures and summarize your data based on selected dimensions. Let's look at a classic Employee table to demonstrate how the Group by function works.

Management would want to focus on metrics like the average salary by region or the minimum experience in each department. To capture insights like these, we need to group and aggregate the employee data, as shown.

Let's look at how we can aggregate your planning data with Infobridge.

### Group by with a single measure Let's find the minimum interest rate for each quarter. We need to choose *Quarter* from the **Category** dropdown, *Minimum* from **Operations 1** dropdown, and *InterestRate* from the **Values** dropdown.

When you click Apply, Infobridge displays the minimum interest rate for each quarter:

Grouped data for a single measure and dimension

### Group by for multiple measures Let's also calculate the average COGS and total sales for each quarter. Click the **Add Aggregation** link to summarize your data for additional measures.

Group by configuration for multiple measures

The summarized data after applying the group by transformation is shown below.

### Group by for multiple dimensions Let's capture more insights by aggregating the same measures for each quarter and country. When you want to summarize your data based on multiple dimension categories, you can select them from the **Category** dropdown.

Grouping data based on multiple dimensions

The summarized query after applying the group by transformation is shown below.

--- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation by asking a question. Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters: ``` GET https://docs.inforiver.com/infobridge-wb-matrix-only/9.-data-transformations/group-by.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.