How to Create Bump Chart in Tableau

 

How to create a Bump chart in Tableau?

In this section, we will learn in a stepwise manner how to create a bump chart in Tableau. Follow the steps given below and make your first bump chart in Tableau.

Step 1: Add dimension and measures

To start creating a bump chart, open a new worksheet in your Tableau Desktop or whichever version of Tableau you are using. Firstly, we need to add two dimensions and a measure. From our dataset (sales of an electronics store), we add Order Date and Region from the Dimensions section and Sales from the Measures section.




Note that we add YEAR(OrderDate) into Columns section, SUM(Sales) into Rows and Region into the Color box of Marks pane.

Step 2: Select a Quick Table Calculation

Right-click on the SUM(Sales) field to access options for it. From the drop-down list, we select a Quick Table Calculation option and then select Rank.


Step 3: Select a field to compute

Next, we right-click on the SUM(Sales) field to access options for it. From the drop-down list, we select the option Compute Using and then select Region as our criterion for computing.



This will arrange the lines of the line chart according to the ranks of their data points. Also, right now that measure values are continuous type which we need to make Discrete.



discrete measure values


line bump chart in tableau showing ranks

The chart we have by default is set in a Standard view mode, we can change the mode to Entire View to fit the chart on the editing canvas.


Step 4: Duplicate measure

In the next step, we duplicate our measure SUM(Sales). This will give us two separate line charts as shown in the screenshot below.



Step 5: Change mark type

In order to create a bump chart, we need to convert the mark type of the second (duplicate) line chart measure SUM(Sales). We change the mark type of this measure from lines to circles. Select the option Circle from the drop-down list of mark types.


Next, we click on the Show mark labels from the Labels box so that the rank labels appear on the circles of the second chart. You can format the labels with more options given in the label editor.



Step 6: Select Dual Axis

Now, so far we have two different charts one showing the data trends by a line and another showing data points by circles and ranks on them. To make a bump chart, we need to merge these two charts together. To do this, right-click on a measure field SUM(Sales) and select the option Dual Axis from the drop-down list.



This does two things, first, it merges the two charts into one and second, it adds one more axis on the right of the chart.



Step 7: Final Bump chart

With this step, our bump chart is ready. Here, we made a bump chart in tableau to show year wise sales for four regions and the progression of their ranks with respect to each other over the years. All four regions i.e. Central, East, South, and North are assigned specific colors.

Consider the Central region that is indicated in yellow, we can see that the total sales for this region remained 3rd highest for two consecutive years, which were 2016 and 2017. Then it went down to 4th rank in 2018 and again regained the third spot in the year 2019.


So, this is how bump charts work to represent rank wise progression of data points with respect to a certain dimension.

Comments

Post a Comment

Popular posts from this blog

How to Create Dashboard in Tableau Steps

Image
  How to Create a Dashboard in Tableau Understand the importance of creating dashboards and learn to build a simple Tableau dashboard by following a visual guide. May 2022  · 16 min read What is the Purpose of a Dashboard? A car dashboard provides real-time information about a car's speed, fuel volume, RPM, and other engine-related indicators. Similarly, a data dashboard provides information about company historical sales, key performance indicators (KPIs), sales growth, operational indicators, and customer feedback. This information is presented in a precise manner so that managers or executives can understand the situation and make appropriate decisions.  There are hundreds of moving parts in your business and a dashboard summarizes these events into an easy-to-understand, real-time data visualization. These visualizations and charts can be used to make fast and effective decisions. Dashboard by  Freepik  | edited by Author There are several benefits of dashboard reporting: Usabi
Read more

Tableau Charts Uses.

  Tableau Charts and What and Use .                                                                A Pareto chart 1. . A Pareto chart is a type of chart that graphically represents the relative frequency or size of different categories or factors. It is named after Wilfredo Pareto, an Italian economist who observed that 80% of the wealth in Italy was owned by 20% of the population. The Pareto chart is based on the Pareto principle, which states that roughly 80% of effects come from 20% of the causes. The chart consists of a bar graph and a line graph. The bars are arranged in descending order of frequency or size, and the line graph represents the cumulative percentage of the total. The chart helps to visually identify the most significant factors contributing to an outcome, and can be used for quality control, productivity improvement, and decision-making. Some common uses of Pareto charts include: Quality control: Identifying the most common defects or
Read more

How to Create Text Visualisation in Tableau

Image
  f we load one of these files into Tableau (I'll stick with Don Quixote, but feel free to use whichever book you like best!), we get something that looks like: Let's pop over to a new sheet and see what we can do! If we drag the  Words  dimension onto the  Text  mark, we can view all the unique words in the book: ...well, almost. See how we only get partway through the As? There are too many unique words to fit! No problem, let's make a filter to show only those that appear at least 50 times: That's a little better: Let's see what happens if we try using  Word Count  to drive the  Size  mark: Ooh, sort of like a treemap! Let's switch from an  Automatic  mark type back to  Text : Hey, that's starting to look like a word cloud! There's just one problem: now that we've mapped  Word Count  to  Size , it's easy to see that the most frequently used words aren't actually very informative. That's okay, we can filter again! This time, let's b
Read more