Multi Select Variables?

I am building a dashboard that analyzes what the specific categories of items in any given transaction.

For this example, let's assume there are 4 potential categories [Milk, Eggs, Bread, Fruit] on any given order.

The end goal is to allow the user to select one or more of these categories in a slicer card (or similar), and have all orders filtered to only those that include each of the selected categories.

My data is roughly structured as follows:

ORDER_ID | CATEGORY_MIX

1 | Bread, Fruit

2 | Fruit

3 | Milk, Bread, Fruit

4 | Eggs, Fruit

Is there a way that the user can click on 'Fruit' and 'Bread' and return only orders 1 and 3 since they were the only ones that had all categories the user selected?

I have cobbled together a freeform text variable with a beast mode that sort of allows this, but it's not super user friendly

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Currently, variables are only single-select. I'd recommend adding an idea to the idea exchange to get variables to allow for multi-select.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Currently, variables are only single-select. I'd recommend adding an idea to the idea exchange to get variables to allow for multi-select.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**