Slicer: Show single values from multiple selection attributes

PJG
PJG Member
in Charting

In our database, we have a multiple selection attribute called Site. In our Dataset, it's shown in a column like these examples with a pipe symbol being the delimiter:

Project 1: Rome | London

Project 2: London | Paris | New York | Melbourne

Project 3: Paris | Melbourne

If I select this attribute as a slicer, it shows me every combination that exists in this attribute, i.e. exactly as they're listed above. I don't want that - I want it to show only the individual sites. Then, for example, if someone selects London, Project 1 & 2 would be shown.

Is this possible?

Answers

  • ColemenWilson
    ColemenWilson Coach

    Yes. You can pivot out the data so that every city is it's own row of data. You can do this in Magic ETL using the Split Column and Dynamic Unpivot tiles.
    1. Split the values into new columns using the Split Column tile. Be sure to choose "|" as the delimiter.
    2. In the Dynamic Unpivot tile, choose your Project # and Project values as columns not to be pivoted.
    3. Use the Filter Rows tile to remove any null values for the pivoted values
    4. Drop the 'Names' column from the Dynamic Unpivot
    5. Final result looks like this:

    Screenshot 2025-03-24 at 9.54.43 AM.png

    6. When building cards, you will have to construct them such that values aren't duplicated. I don't know how you are trying to visualize this data, but this gets you to that step.

    If I solved your problem, please select "yes" above

Categories