Create a custom multi-select (all that apply) column

AddMaple has an intelligent engine for detecting multi-select columns, however it is not possible to always detect this accurately.

If AddMaple hasn't detected and merged a group of columns into a single "multi-select" column then you can use the "Custom Column/Variable" feature.

If you have many columns on your dashboard with only one category showing 100% then it is likely you need to follow this workflow.

1

Dashboard showing many 100% single-category columns — a sign you should merge into a multi-select.

From the "More" menu, click "Custom Column/Variable"

2

Open the More menu and choose Custom Column/Variable.

Make sure to select "Overlapping (categories can overlap)" in the dropdown on the right. This will allow the resulting column to have more than one value for each row—which is how multi-select or "all that apply" columns work.

3

Select Overlapping so each row can have more than one value.

Add categories for each option for your multi-select column. In this example we have created 3 categories for 3 columns. The result will be a new column where we see the "Category A", "Category B" and "Category C" options in the same column.

4

Add categories for each source column; the result merges them into one multi-select column.

After setting up your column, click "Create Column". A new column will be created, ready to pivot and explore.