A bump chart in Tableau is a special visualization designed to track the ranking of items over time. Instead of showing absolute values, it displays changes in rank, making it easier to see trends, moves, and shifts in the position of data across multiple categories. In Tableau, bump charts are particularly useful for presenting competitive performance, sales rankings, or any situation where relative position is necessary for analysis. By visualizing the rise and fall of an item’s rank over time, bump charts provide clear information about trends that may not be apparent in traditional line or bar charts.
When to use Bump Chart in Tableau
Comparing rankings over time
When analyzing how the rank of specific items—such as products, teams, or individuals—changes over different periods of time, bump charts provide an intuitive way to visualize these changes.
Tracking competitive performance
In contexts such as sales or market share analysis, bump charts help visualize how competitors perform relative to each other over time, making it easier to identify trends and patterns.
Visualizing performance metrics
For organizations monitoring key performance indicators (KPIs), bump charts can show how different departments, teams, or individuals rank against their goals over time.
Identifying trends in motion
Bump charts allow users to quickly identify up or down trends in rankings, highlighting success stories or areas in need of improvement.
Importance of bump charts
Clear visualization of ranking changes
By focusing on ranks rather than raw values, bump charts make it easier to see how items compete against one another, providing immediate insight into their relative performance.
Highlighting trends and shifts
Bump charts effectively capture the dynamics of data over time, allowing users to identify trends, peaks, and valleys in rankings, leading to actionable insights.
Facilitate quick comparisons
With the ability to visualize multiple items in a single chart, bump charts enable quick comparisons and can reveal unexpected patterns or correlations.
Engaging storytelling
Bump charts enhance storytelling in presentations or reports by illustrating progress and competitive positioning, making data more relatable and understandable to stakeholders.
Steps to create Bump Chart in Tableau
Step 1: Open Tableau
Step 2: Click on Text file to connect with Tableau
Step 3: Browse csv file (or other file format as your need) and click on Open
Step 4: Data has been loaded, now click on Sheet 1
Step 5: Drag-n-drop Date to Columns and Sales Amount to Rows
Step 6: Right click over Year of Date (in Columns) and select Month (May)
Step 7: Drag Region from Data pane and drop over Color (in Marks card)
Step 8: Click on dropdown option with Standard and select Entire View
Step 9: Right click over sum of Sales Amount (in Rows) and select Quick Table Calculation for selecting Rank
Step 10: Again, right click over sum of Sales Amount (in Rows) and select Compute Using for selecting Region
Step 11: Right click over Header (Rank of Sales Amount) and select Edit Axis…
Step 12: Mark on Reversed and rest will be same.
Step 13: Drag (Right) sum of Sales Amount (in Rows) using ctrl and drop on right
Step 14: Right click on second sum of Sales Amount (in Rows) and select Dual Axis
Step 15: Click on Second sum of Sales Amount section (in Marks card); Click on dropdown with Automatic and select Circle
Step 16: Right click over Header (Right side) and select Synchronize Axis
Optional Step 1: Again, right click over Header (Right side) and select Show Header to unselect it (hide)
Optional Step 2: Right click over Date Field Label and select Hide Field Labels for Columns
Output:
Note:
- Rankings over time: Each region’s rank fluctuates over the months, helping us see which regions are consistently performing well (such as the East, which is mostly at the top) and which need attention (such as the South, which is at the bottom).
- Competitive dynamics: The North and West regions frequently change ranks, showing more competitive dynamics between them. The bump chart makes it easier to see this back-and-forth competition.
- Pattern recognition: The East region’s stability at the top (rank 1) and the South’s consistent position at the bottom (rank 4) are clearly visible in the bump chart, helping decision makers quickly identify where changes are stable or unstable.
Conclusion
Bump charts in Tableau are a powerful tool for visualizing changes in rankings over time, providing clear insights into competitive performance, trends, and shifts. Their focus on rank rather than absolute values allows analysts to uncover valuable information that may be overlooked in traditional visualizations. Using bump charts, organizations can effectively monitor KPIs, track performance and communicate changes in competitive positioning, as well as engage stakeholders with an intuitive visual narrative. Whether for internal performance reviews or external market analysis, incorporating bump charts into your data visualization strategy can significantly enhance your ability to interpret and present complex datasets, facilitating informed decision making and strategic planning.
If you like the article and would like to support me, make sure to:
- 👏 Like for this article and subscribe to our newsletter
- 📰 View more content on my DataSpoof website
- 🔔 Follow Me: LinkedIn| Youtube | Instagram | Twitter
