## How to create a compass map in Tableau

by Vikash Bhardwaj

In this post I’ll be covering how to make a compass map. I’ve attached a link to a downloadable workbook at the bottom and have included all calculations throughout the blog.

So lets begin with some context,

It’s day 2 of dashboard week and we were tasked to look at flight information.

An aspect of my dashboard was to look at delays and if there were any trends occurring with wind direction and weather related delays.

The first thought of visualizing this was to create a bar chart;

However that’s really not very interesting engaging.

After completing the project and when cleaning everything up I thought about if it could be represented on a compass.

After some googling, and help from other blogs, I found a way to create this in Tableau;

And will now share with you the the steps it took.

PS please ignore the name of my dataset – it was a tough day.

## Step 1 – Converting direction to degrees

Since wind direction was already shown in my data set I created a calculated field to assign the relevant degrees to each value.

I’ve attached the formula at the bottom of the blog if you’d like to copy it;

## Step 2 – Converting degrees to radians

I then created a calculated field which converted degrees to radians. I didn’t want to do this without step 1 just incase I made an error.

## Step 3 – Creating Eastings and Northings

After creating the radians I created 2 more calculated fields for the Eastings and Northings using some trigonometry. The formulas are as follows;

Eastings;

``SIN(SUM([Radians])) * SUM([Wind Speed])``

Northings;

``COS(SUM([Radians])) * SUM([Wind Speed])``

## Step 4 – Assigning Northings and Eastings

Drag Northings into the columns and Eastings into the rows and add what you’d like to separate onto detail in the marks card.

Now you should have a radial map!

## Step 5 – add the compass background.

Firstly, find a compass you’re happy with (I found mine on freepik.com). Now ensure the ratio of the image is 1:1 and that centre of the compass is in the exact centre of the image.

Now go back into your worksheet and follow the diagram – selecting the data source you’re using

In the window that appears select “Add Image” and the following window should then pop up;

Select the image you would like from the ‘Browse’ button and edit the axis. Be mindful for the scale of the axis as you would like the compass to be in the center of the screen.

## Step 6 – Touching up

Edit the marks and you’re done! I added some hurricane icons as shapes and also put windspeed on size to further emphasis where the wind doth blow.

I hope this post has allowed you to see that there are always different ways of visualize data and makes you think of searching for new ways in the future.

If you wish to go out If you have any comments, tips or suggestions please feel free con contact me on Twitter or Linkedin.

As promised, the calculation for assigning degrees;

``````IF	[Wind direction]	=	"Northest"	THEN 	315
ELSEIF	[Wind direction]	=	"North"	        THEN 	0
ELSEIF	[Wind direction]	=	"Northeast"	THEN 	45
ELSEIF	[Wind direction]	=	"East"    	THEN 	90
ELSEIF	[Wind direction]	=	"Southeast"	THEN 	135
ELSEIF	[Wind direction]	=	"South"	        THEN 	180
ELSEIF	[Wind direction]	=	"Southwest"	THEN 	225
ELSEIF	[Wind direction]	=	"West"	        THEN 	270
END``````

Vikash Bhardwaj

Wed 20 May 2020

Tue 12 May 2020

Fri 24 Apr 2020