Count the number of instances of values across multiple dimensions in Tableau

Question

I'm currently looking to count the number of instances values shared across multiple dimensions. For example, say I have the following set of data:

And I want to return something like:

But ideally in the form of a bar graph. I want to keep the names associated with the data, so I can filter let's say by all "Bobs" or all "Hannahs".

Does anyone have any advice on how to do this in Tableau?

Answer 1

These are a few ways you would be able to do this.

• Create a calculated field for each food type. This is a bit cumbersome and you would need to add new ones for any new foods added. Your calculations would look like this:

• Hamburgers: SUM(IF [Food1] = 'Hamburgers' OR [Food2] = 'Hamburgers' THEN 1 END)

• Now make use of the Measure Names and Measure Values built-in fields.

•  You can normalize your data. If you are referencing an Excel or Text file, you can do this right in Tableau. No go to the Data Source tab, select the Food fields, and choose to Pivot them:

Goes to:

Now you can do:

---

Finally, both results support creating a bar chart:

You can check Tableau Desktop Certification program to learn more about tableau from basic to advance level.