January 1, 2022

# Isotype Plots in Tableau

By Luke Stanke

## What are Isotype Plots?

Isotype plots are a blend ofÂ visual languageÂ that emphasizes quantitative data with symbolism that is often associated with descriptive imagery. If you wanted to simplify it its very similar to aÂ pictogram.Â

The example above by Jason Forrest and McKinsey is a great example. But how do you do this in Tableau?

Caveat: You need at least 10 values per member to create this chart type (unless you are going to have a different number of images displayed). This shouldnâ€™t be an issue if you are showing averages because any less would be inappropriate to report on. If youâ€™ve got data that is already rolled up to a single row of data, then this will not work for you.

## Step 1: Create the Background for the Isotype

Create a calculation called Isotype.

```				```
// Isotype
FLOAT(IF INDEX() <= 10 THEN INDEX() END)
```
```

1b. Our example shows the percent of orders that were profitable by Sub-Category.

1c. Add Sub-Category to rows. Also add Order ID to detail on the marks card.

1d. Edit the table calculation on Istotype and select Order ID.

1e. Change the mark type to shape and choose a custom shape.

1f. Set the range from 0.5 to 11.5.

## Step 2: Create the Focal Metric

Create your metric: percent of orders that are profitable. This is a percentage that ranges from 0% to 100%. Call the field Order | Profitable.

```				```
// Order | Profitable
COUNT(IF [Profit] > 0 THEN 1 END)/COUNT([Orders])
```
```

## Step 3: Create the Block

The block will cover some (or all or none) of the pictures that are on the worksheet. Weâ€™ll also show labels (which are difficult) Create a calculation called Block.

```				```
// Block
FIXED [Sub-Category] : 10*[Order | Profitable]}
```
```

3b. Create a dual axis.

3c. Set the axis from 0 to 11. Do NOT synchronize the axes.

3d. Set the mark type to gantt.

## Step 4: Add Detail to the Block

The labels can be challenging but you can use a little trick to make the labels more intuitive. Create a calculation called Orders to show.Â

```				```
// Orders to show
IF [Order ID] = {FIXED [Sub-Category] : MIN([Order ID])}
THEN "A"
ELSE "B"
END
```
```

Add this calculation to the Block marks card.

## Step 5: Size the Block Bars

Weâ€™ll size the gantt bars now. Create a calculation called size.

```				```
// size
IF [Order to show] = "A"
THEN 0
ELSE 10*(1 - {FIXED [Sub-Category] : [Order | Profitable]})
END
```
```

Add to size on the gantt bar chart. Match the color of the bar to the background.

Create a calculation called Labels.

```				```
// Labels
IF [Order to show] = "A"
THEN {FIXED [Sub-Category] : [Order | Profitable]}
END
```
```

Add the calculation to label on the gantt marks card and right align the text.Â

The result is an isotype.

Thanks so much for reading! Need more help making your Tableau dashboards a work of art? Our knowledgeable team of Tableau experts is here to help!

## More to explore

Snowflake

dbt

AI & ML

### How to Generate Personalized Emails from your Snowflake CDP with Snowflake Cortex, Snowpark, & Hightouch

Data Coach is our premium analytics training program with one-on-one coaching from renowned experts.