Tableau has a rich collection of charts that can be used for different types of analysis. Apart from the built-in charts, developers can custom create new ones using the features of Tableau.
Bump charts are very useful for comparative analysis and in understanding trends over a period of time. In this blog let’s learn the steps to build a bump chart, with an example scenario – comparing sales trends in different regions across months of 2017.
1. Build the following chart:
2. Convert the ‘SUM(Sales)’ green pill in Rows to a Rank table calculation:
3. The problem here – as seen in the image above, is that ranking has been done based on the sales across the months, for each region. But we need the ranking to be done based on sales across the regions, for each month. So, we would need to change the level at which the table calculation takes place. Change the ‘Compute Using’ option for ‘SUM(Sales)’ from ‘Table (Across)’ to Compute Using Region. After changing the computation level, we get the following output:
4. Duplicate the ‘SUM(Sales)’ pill and place it beside the original pill in Rows and create a dual axis:
5. Convert ‘Marks’ of one of the Measure Axis to ‘Circle’ and add the ‘Rank of SUM(Sales)’ as the ‘Text’ for the Labels. Change the ‘Alignment’ of the labels’ text as shown below and hide the axis on the right side of the chart:
6. Finally, edit the axis and reverse the scale. Right click on the axis and select the option to bring the marks to the front. We get the final output as shown below:
We can now easily compare the performance of each region in a month, based on the Rank value shown in the respective labels, and track the growth of the regions over a time period.
We can create many more custom visualizations in Tableau by using its built-in features, which we will focus on, in our subsequent blogs.
You can catch up on our other Tableau blogs here.