đ Use code DEC100 to get 20% off any AddMaple planâlimited to the next 100 subscribers! đ
Search
Contents
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.
Here are the three âmentionâ columns. While they are not identical, you can see that they contain similar categories.
First, expand one of the columns you want to group. Then, click the options menu and select âGroup Columns.â
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.
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.