The grouping feature in Report Builder is a useful tool for creating meaningful reports out of the data you have collected. Grouping on a specific column in a report creates a row of data for each answer that has been collected in that column; each date, each name, each service, etc. You can also group on several columns of data in the same report section, which can make your data easier to understand at a glance. If you need to use a graph for your data, grouping can make your graph easier to understand.
Note: You can only group up to 4 columns. Any more columns grouped after 4 will be combined on to the fourth grouped column.
A Report Before Grouping:
A Report After Grouping:
This report section shows the students who are entered into the "Breakfast Program." We can see their names, the dates they received breakfast, if they reported hunger, if they were referred for other services, and their gender.
Grouping can help us if we want to see:
- What has happened for each client: We can "Group" on the client name to see a row of data for each person.
- Data for each age: We can "Group" on the age to see a row of data for each number listed under the Age column.
- What happened on each Date: We can "Group" on the date column to see data for each date a service plan was created.
- How many boys versus girls were served: Grouping on gender can show us at a glance how many males and how many females were served.
To Access Grouping:
- Click the green gear box at the top of the column you would like to group.
- Under "Group By This Column," select "Yes." The title of your column will turn white so you can identify it when looking at your report section.
- Click "Apply."
A Report With Grouping:
- We are now grouping this report section on the data in our gender column. The column header title has turned white, to identify it as the grouped column.
- We now have a row of data for female clients served and male clients served.
- To hide the row results, collapse the black arrow. In the Report Builder (the edit side of reports), the rows will only preview for the first grouped result. In the run version of your report, these can be expanded for all the grouped results.If you have more than 5 groups in your report, the Report Builder will only show the first five groups. All groups will appear on the run side of the report.
- We still get the "Total Rows" result, showing all the breakfasts that were served.Depending on your Section Count setting it may not be on "Total Rows" and you may find more information with Report-Counts Article.
Graphs with Grouping:
Grouping is an easy way to make graphs easier to read and more meaningful at a glance.
- You can tell we are grouping on the gender column because the column header title is white.
- Use the report section gear icon to turn on the graph in the section's properties.
- Use the graph gear icon to adjust what kind of graph you want to use for the section.
Grouping on More Than One Column:
Here we are using grouping on several columns.
- By grouping on the "Gender" column, we get a row of data for each gender we have served. In the example above, we get a row for female and a Row for male.
- We are also grouping on the first name, so we have a row of data for each person we served.If you have more than 5 groups, only the first five will be displayed in the Report Builder. All groups will be displayed in the run version of the report. The left-most grouped column corresponds to the topmost level of grouping. If you want to change the order of grouped data, you can drag a grouped column to the leftmost position. If we wanted to see who was served on each date, and therefore wanted to date field to be the first column that was split out by grouping, we would move that column to the left of the name column.
Grouping in Run Mode:
Clicking any of the black arrows next to a row of data will expand to show the results.
Group by Assigned Programs (System Field)
With the introduction of Programs you can now group on the Assigned Programs field. In some scenarios, it may be beneficial to use the Assigned Programs field instead of a different field on your form. This won't be every situation but lets say we have a Pop Program, Country Program, and Rock Program. We will use the same data set as the previous examples, now lets say each record was assigned to it's respective programs based on what was previously selected in the Multi-Select Field. We will see that grouping actually works by splitting each Program onto it's own line, regardless of how many Programs the record is assigned to.