Tableau charts: Bump chart

February 21, 2018

The series, Tableau charts has always focused on one thing, helping Tableau users learn how to create different charts and graphs hence equipping them with different techniques of telling each data story. 

Inspired by the spirit of this series, we'll learn how to create a Bump chart using Superstores data set pre-loaded in Tableau app, our goal is to visualize how Product Sub-category's have performed in Sales for different months of the year by ranking them.

But,.. first lets create a calculated field to Rank Sales along the Sub-category's.

 Under, 'Default Table Calculation'. Compute the Table rank using Sub-category. See below.

 Lets build our chart.

  • Drag dimension field Order Date to the Columns shelf. Change the level of detail from Year to Month.

  • Drag dimension field Sub-Category to the Detail tab under the marks card.

See the resulting chart.

  •  Next, Drag the Calculated field Rank above to the Rows shelf, see the results below.

Duplicate the chart by (hold down Ctrl key) dragging the field Rank on the Rows shelf next to itself. See below.

Make the charts dual and synchronize the axis.

Note that the axis are in reverse, to correct this.

  • Right click on the axis >> Edit axis.. >> select Reversed under Scale.

See the resulting chart. (With ranks, arranged accordingly).

Select the Second chart and change the chart type to a Circle, make sure the First chart remains to be a Line.

 Drag, the field Sub-category to the color tab under the marks card for both the charts.

Select the second chart (Circles). Drag calculated field Rank to the Label tab, Open the Label tab and align the labels to the center. See below.

Doing some formatting and editing we've.

And there we have it. From the above chart, it is clear that Fasteners' were ranked last across all the months (It's a product with few Sales), while Phone's & Chair's ranks, varied between one and three (These are products with huge Sales).

I hope this article was useful to you.

Thanks for reading.

 

Share on Facebook
Share on Twitter
Please reload

Featured Posts
Please reload

YOU MIGHT ALSO LIKE
Please reload