Last week we released a tutorial about the new Distance function in Tableau 2019.3; I really love this function and can see so many interesting applications. This week we are going to look at the HEXBINX and HEXBINY functions to see if we can have more fun with maps in Tableau.
Firstly, we will grab some geographic data from Airbnb and load this into Tableau. Click on the following link and download and load into Tableau the file for your desired city: http://insideairbnb.com/get-the-data.html
Note: I am from London, so I will base the tutorial on London. But it does not matter which city you choose.
We will start by creating the following Calculated Fields and Parameters.
Parameter called Size
- Name: Size
- Data type: Integer
- Current Value: 20
- Display format: Automatic
- Allowable values: All
We will now create the following Calculated Fields.
Maps an x, y coordinate to the x-coordinate of the nearest hexagonal bin. The bins have side length 1, so the inputs may need to be scaled appropriately.
HEXBINX and HEXBINY are binning and plotting functions for hexagonal bins. Hexagonal bins are an efficient and elegant option for visualising data in an x/y plane, such as a map. Because the bins are hexagonal, each bin closely approximates a circle and minimises variation in the distance from the data point to the centre of the bin. This makes the clustering both more accurate and informative.
and that is it, we are ready to build out data visualisation.
Our workshop is pretty simple.
- Double click on Latitude and Longitude to add them to your view.
- Right-click on these objects and convert them to Dimensions.
- Now click on the Size Mark and reduce the Size to the minimum.
You should now see the following:
Now, let us have some fun with Colors, drag HexbinY onto the Color Mark, you should see something like the following:
Let us now drag HexbinX onto the Color Mark:
Finally, drag Color onto the Color Mark.
and boom, we are done. Don’t forget to change the Size Parameter to see the effects of our scaling. I hope that you have found this interesting and fun, and as always, you can find my data visualisation on Tableau Public here https://public.tableau.com/profile/toan.hoang#!/vizhome/HexbinMaps/HexbinMaps
I hope you all enjoyed this article as much as I enjoyed writing it. Do let me know if you experienced any issues recreating this Visualisation, and as always, please leave a comment below or reach out to me on Twitter @Tableau_Magic.