Add Maple

Search

Contents

User Guide

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

AddMaple has an intelligent engine for detect 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 "Segment or Merge" feature.

1

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

example problem
2

From the options menu, click "Segment or Merge"

segment or merge
3

Make sure to select "Overlapping" 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 works.

overlapping option
4

Add segments for each option for your multi select column. In this example we have create 3 segments 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.

multi-select setup

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

Bar Chart

Other Articles

Bar Chart