Add Maple

🎄 Use code DEC100 to get 20% off any AddMaple plan—limited to the next 100 subscribers! 🎁

Search

Contents

User Guide

Grouping Columns

AddMaple supports grouping columns with overlapping categories, which is especially useful for aligning data across similar questions. This grouping often happens automatically for opinion scales, but you can also manage it manually when needed.

This example demonstrates grouping three different “mention” columns. After cleaning the data in AddMaple by merging similar mentions, we’ll now show you how to group these columns together so you can explore the grouped totals.

1

Here are the three “mention” columns. While they are not identical, you can see that they contain similar categories.

3 mention columns
2

First, expand one of the columns you want to group. Then, click the options menu and select “Group Columns.”

group menu
3

A dropdown will appear in the sentence builder, allowing you to select the columns you’d like to group together. Only columns with overlapping categories will be displayed as options.

Once you’ve selected your columns, the pivot chart will update automatically to display all your grouped columns in a single chart.

4

Often, you’ll have more categories than grouped columns. In such cases, it’s often more effective to swap the columns and rows. You can easily do this by toggling the “Swap Columns and Rows” option on the left side of the pivot chart.

In this example, swapping the columns and rows allows you to see the artists mentioned across all three grouped columns, ordered by the total mentions.

Bar Chart

Other Articles

Guide

Sorting table columns

Guide

Chi-Square Test

Bar Chart