Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in BI by (17.6k points)

I have a field from the data I am reading in that can contain multiple values. They are essentially tags.

For example, there could be a column called "persons responsible". This could read "Joe; Bob; Sue" or "Sue" for a given row.

Is it possible from within Tableau to read these in as separate categories? So that for this sample data:

Project     | Persons

---------------------------

Zeta        | Bob; Sue; Joe

Enne        | Sue

Doble Ve    | Bob

There could be a count of Bob (2), Sue (2), Joe (1)?

I am working on getting better data inputs, but I was wondering if there was a temporary solution at this level. 

1 Answer

0 votes
by (47.2k points)

In case, if there is a small set of possible values for the tags (persons in your example).If Bob, Sue, and Joe are the only people in the system, you can use the contains() function to define a boolean calculated field for each person. Let's look at this example, Bob_Is_Responsible = contains(Persons, 'Bob"), and similar fields for Sue and Joe. To break the data up in different ways, you could use those as building blocks, possibly with sets.

Intellipaat offers Tableau Desktop Specialist Certification training for the learners to master advanced visualization tools.

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94.1k users

Browse Categories

...