Table Row Grouping

Group rows in the table view to organize your data by category and view summary values.

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.

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.

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