Build a Bar Chart Race on COVID-19 Cases in Tableau version 2020.1 onwards

Build a Bar Chart Race on COVID-19 Cases in Tableau version 2020.1 onwards

To build a bar chart race is to create many discrete pages of bar charts and then string them together, just like how a traditional cartoon animation is built. In Dec 2019, Tableau released 2020.1 beta version with a new Animations feature for dynamic parameters. This means that the bar chart race below is now very easy to build.

Pre-requisites

Download and install Tableau Public (latest version 2020.1.2 onwards). It is free of charge with full functionality. The only snag is that any work done can only be published on the Tableau Public server, and not saved locally to your Desktop. This is alright if the data is not sensitive or private.
Download the latest COVID-19 data (in *.xlsx format) from the European Centre for Disease Prevention and Control website, and rename it using a generic filename “COVID-19-geographic-distribution-worldwide.xlsx”. You can replace this file with the updated data later, using the same filename.

  • Open the Tableau Public app, and connect to the downloaded data file (click on “Microsoft Excel”). Click on the “Sheet 1” tab at the bottom left.

DATA: www.ecdc.europa.eu/…/COVID-19-geographic-disbtribution-worl…

Identify the Quantity to Race

  1. There are 2 useful quantities you can choose to race in this dataset:
  2. Daily Infected Cases, or Daily Deaths Cases.
  3. To choose the race quantity as daily infected cases:
  4. Drag “Cases” to Columns.
  5. To label the bar chart with country names:
  6. Drag “Countries And Territories” to Label.
  7. To have the bars in various colours:
  8. Drag “Countries And Territories” to Colour.
  9. Create Rank for Countries
  10. This section requires a simple programming line of code.
  11. Click on Dimensions → drop-down menu → Create Calculated Field.
  12. Create a new field “Rank”, and key in the code below.
  13. RANK_UNIQUE(Sum([Cases]))
  14. Click on “Apply” to ensure that calculation is valid, then click “OK”.
  15. Drag “Rank” to Rows.
  16. Click on (Rows) Rank → drop-down menu → Discrete.
  17. Click on (Rows) Rank → drop-down menu → Calculate Using → “Countries And Territories”.
  18. Configure Animation (New Feature for Ver 2020.1)
  19. To create a snapshot of animation frames:
  20. Drag “Date Rep” to Pages.
  21. Click on (Pages) Date Rep → drop-down menu → Exact Date.
  22. Turn on animations:
  23. Format → Animations → On.
  24. To set the transition duration: Duration → “1.00 seconds (Slow)”.
  25. Close Animations window by clicking “X”.


Look for a little Animations control which appeared when the animations feature is turned on, and click the “forward play” icon. Drag the slider bar to a different date or use the left/right button to choose a date.

Animations control

Add Simple Customisation

1. To improve colours:
  1. Click on Label → ensure “Show mark labels” is checked.
  2. Click on Colour → Edit Colours -> replace similar colours if any.
  3. (I have replaced the colours for the USA, Spain, Italy)
  4. Hide the Countries legend card, no need for it anymore.


2. To add additional labels for the number of cases to the bars:

  1. Drag “Cases” to Label.
  2. Click on Label → Text → click on “3 dots”. This opens up the label editor.
  3. Arrange labels to 1 line only.
  4. Underline <Countries And Territories>.
  5. Bold <SUM(Cases)>, and use a red font.
  6. Click on “OK”.

Label editor

3. To change the sheet name:
Double-click on “Sheet 1”, and change it to “COVIT-19 Daily Infected Cases”.


4. To change X-axis limits:

  1. Double-click on the X-axis, this brings up the Axis menu.
  2. Choose Range to be “Fixed”, Fixed start=0, Fixed end=40,000.

5. To display only the top 15 countries:

  1. Drag “Rank” to Filters → click on “OK”.
  2. Click on (Filters) Rank → drop-down menu → Compute Using → “Countries And Territories”.
  3. Replace “206” with “15”, and click on “OK”.
  4. Change the Standard view to “Fit Height”.


6. To increase label font size:

  1. Click on Label → Font → drop-down menu → change to font size “15”.

7. To add data label on the chart:

  1. Right-click on the empty chart area → Annotate → Area.
  2. This brings up the annotation editor.
  3. Key in <Page Name>, and increase the font size to “20”.
  4. Click on “OK”.

The date label is created. Resize and locate it at the bottom.


Publish Visualisation

When you are satisfied with the customisation, the visualisation is then ready to be published.
  • Click on File → Save to Tableau Public.
The work is now published on the Tableau Public server. You can then share it using the available link.
Here’s a video tutorial with a step-by-step guide for the entire process:

A bar chart race becomes very simple to build using the new Animations feature in Tableau Version 2020.1 onwards. You can now try it on other country data with date/time series: GDP, Population, Life Expectancy, etc.
Let your creativity flow!
follow link:https://towardsdatascience.com/how-to-build-a-bar-chart-rac…

Comments

Post a Comment

Popular posts from this blog

AI for Product management in 2025

Image
 AI is increasingly being integrated into product management to streamline processes, enhance decision-making, and improve user experiences. Here's how AI can be applied to product management: 1. Product Strategy and Planning Market Analysis: AI can process vast amounts of market data, customer behavior, and competitive analysis to offer insights into market trends and customer needs, helping define product roadmaps. Demand Forecasting: Using predictive analytics, AI can forecast demand, sales trends, and customer preferences to guide product development efforts. 2. User Research and Feedback Sentiment Analysis: AI-driven sentiment analysis tools can analyze customer feedback, reviews, and surveys to understand customer satisfaction and identify pain points. Customer Segmentation: AI can group customers into segments based on behavior and demographics, allowing for more personalized products and targeted marketing strategies. 3. Product Design and Development...
Read more

The Complete History of the Bicycle: A Year-Wise Evolution

Image
Introduction The bicycle, a symbol of freedom and innovation, has a rich history spanning over two centuries. From its earliest form as a wooden frame to the high-tech carbon fiber models of today, the bicycle has continually evolved. Join us on a journey through the complete history of the bicycle, presented in a detailed year-wise timeline. The Dawn of Cycling: 19th Century Innovations 1817: The Draisine Invented by Baron Karl von Drais, this was the first two-wheeled steerable machine, essentially a precursor to the modern bicycle. 1863: The Velocipede or "Boneshaker" Developed by Pierre Michaux and Pierre Lallement, introducing pedals to the design. The Age of Elegance and Speed: Late 19th Century 1870s: The High-Wheeler Known for its large front wheel, these bicycles became a symbol of the era. 1885: The Safety Bicycle John Kemp Starley's design introduced equal-sized wheels and a chain drive, setting the standard for future bicycles. 1888: Pneumatic Tires John Boyd ...
Read more

Variable Naming Best Practices in JavaScript 2025 by Hayk Simonyan

Image
Like any other programming language, JavaScript relies heavily on well-structured and understandable code. One of the fundamental building blocks of clean JavaScript code is effective variable naming. By adhering to certain best practices, you can significantly enhance the readability and maintainability of your JavaScript projects. Let’s dive into 12 sets of JavaScript variable naming guidelines. 1. Avoid var Keyword: A Relic of the Past Before ES6, the  var  keyword was the primary way to declare variables. However, it had some quirks and limitations that often led to unexpected results and made debugging more challenging. In modern JavaScript, we generally avoid using  var  and instead opt for  let  and  const , which offer more predictable and block-scoped behavior, making your code easier to understand and maintain. 2. let: Variables That Can Change Use the  let  keyword to declare variables whose values you might need to change later in...
Read more