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.
See the resulting chart.
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.
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.