# Table Row Grouping

### **Group and summarize your data**

* Use row groups to organize your data **in the table view**, which  helps you explore patterns or compare values before deciding what to visualize. 
* In the Columns tab, you can drag a field into the Row Groups section to group your dataset by that column (e.g., group students by grade level or program). The table will collapse into grouped sections, with expandable rows.
* You’ll also see summary values at the bottom of each group (e.g., total students, average GPA). These summaries are especially helpful for spotting trends in large datasets.

<figure><img src="/files/8EhQImkaidTVAfqWDkMO" alt=""><figcaption></figcaption></figure>

### **When to use Row Groups**

* Row Groups are effective at organizing, summarizing, and analyzing large datasets more effectively by creating hierarchical views of their data.
* **Understanding Hierarchical Data**: When data naturally has a parent-child or categorical relationship, row grouping allows users to visualize this hierarchy.
  * For example, a course designer reviewing their LMS data could group learning activities by Module, then by Lesson, then by Activity Type to visualize the course structure and progression.
* **Summarization and Aggregation**: A primary reason to use row grouping is to see summary information for each group, especially in the table view. Doowii can automatically calculate aggregates (like sum, average, min, max, count) for numeric columns within each group.
  * For example, grouping attendance records by Month, then by Student, to see the total number of absences for each student per month
* **Data Exploration and Drill-Down**: Users can collapse and expand groups, allowing them to start with a high-level overview and then drill down into specific details as needed.&#x20;
  * For example, an educator might see a low average score for a particular Assignment Type within a Subject when grouped. They can then expand that group to see individual student scores and identify which students struggled.

### **Controlling the Order of Row Groups**

* After creating 2 or more row groups, you can drag on of your Row Groups higher or lower in the list of Row Groups which will also change the table preview.&#x20;


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://support.doowii.io/top-resources/advanced-charts-and-visualizations-builder/table-row-grouping.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.