Exercise: Olympic Dashboard

You are here:
Estimated reading time: 4 min

Introduction

Welcome to FlexIt! In this article, we will walk you through building a simple Olympic dashboard, step by step. The dashboard will consist of three components:

  • A grid report that shows the gold, silver, bronze and total Olympic medals of each country
  • A stacked area chart of total Olympic medals by county over host year
  • A pie chart of total Olympic medals by sport
Want an extra challenge? Attempt to recreate the dashboard below solely by referencing the image.

Challenge

Use the image above to recreate the Olympic Dashboard, creating each of the three pieces of content solely by referencing the image.

 

Solution: Grid Report

Let’s start by creating a grid report of the gold, silver, bronze and total Olympic medals of each country.

  1. Click the New Analysis button toward the top of the page, in the left panel
  2. Click Samples
  3. Under the Available Fields section, click Medal Metrics to expand the list of options
  4. Drag the Gold Medals, Silver Medals, Bronze Medals and Total Medals fields into the droppable Selected Fields section to the right
  5. Under the Available Fields section, click Country to expand the list of options
  6. Drag the Country field to the droppable Selected Fields section to the right
  7. Scroll to the bottom of the page and click the green Run Report button
  8. Hover over the Gold Medals header of the report and right click
  9. Hover over the Sort option and select Sort Descending to order counties by number of gold medals
  10. Click the disk icon towards the top right corner of the page and select Save to save the report
  11. Click the My Content folder
  12. Name the report and click the Save button

Solution: Area Chart

Second, we will create a stacked area chart of total Olympic medals by county over host year.

  1. Click the New Analysis button toward the top of the page, in the left panel
  2. Click Samples
  3. Under the Available Fields section, click Medal Metrics to expand the list of options
  4. Drag and drop the Total Medals field into the droppable Selected Fields section to the right
  5. Under the Available Fields section, click Country to expand the list of options
  6. Drag and drop the Country field into the droppable Selected Fields section to the right
  7. Under the Available Fields section, click Games to expand the list of options
  8. Drag and drop the Host Year field into the droppable Selected Fields section to the right
  9. Scroll to the bottom of the page and click the green Run Report button
  10. Click the chart icon toward the top right of the page
  11. Select the Chart Only option
  12. Click the area chart icon to the top right, in the second group of icons
  13. Select the ellipsis icon (the three horizontal dots)
  14. Under Chart Type, select Stacked
  15. Click Showing: Top 10 on the right, below the legend
  16. Change the number of top items to be shown to five and click to apply changes
  17. Click on the Others field in the legend to hide the additional results
  18. Click the disk icon towards the top right corner of the page and select Save to save the visualization
  19. Click the My Content folder
  20. Name the visualization and click the Save button

Solution: Pie Chart

Now we will create a pie chart of total Olympic medals by sport

  1. Click the New Analysis button toward the top of the page, in the left panel
  2. Click Samples
  3. Under the Available Fields section, click Medal Metrics to expand the list of options
  4. Drag and drop the Total Medals field into the droppable Selected Fields section to the right
  5. Under the Available Fields section, click Event to expand the list of options
  6. Drag and drop the Sport field into the droppable Selected Fields section to the right
  7. Scroll to the bottom of the page and click the green Run Report button
  8. Click the chart icon toward the top right of the page
  9. Select the Chart Only option
  10. Click the pie chart icon to the top right, in the second group of icons to change the visualization to a pie chart
  11. Click Showing: Top 10 on the right, below the legend
  12. Change the number of top items to be shown to five and click to apply changes
  13. Click on the Others field in the legend to hide the additional results
  14. Click the disk icon towards the top right corner of the page and select Save to save the visualization
  15. Click the My Content folder
  16. Name the visualization and click the Save button

Solution: Dashboard

Lastly, we will turn all the content we have created into one unified dashboard.

  1. Click the New Dashboard button toward the top of the left panel
  2. Select the dashboard configuration to the top right that has two panels split horizontally, with the top panel split in two
  3. Click top left plane of the dashboard to add your area chart
  4. Click the My Content folder  to expand the list of options
  5. Select your area chart
  6. Select the Done button on the following window and your area chart will be added to the left dashboard plane
  7. Click top right plane of the dashboard to add your pie chart
  8. Click the My Content folder to expand the list of options
  9. Select your pie chart
  10. Select the Done button on the following window and your pie chart will be added to the right dashboard plane
  11. Now click the bottom plane of the dashboard to add your grid report
  12. Click the My Content folder  to expand the list of options
  13. Select your grid report
  14. Select the Done button on the following window and your report will be added to the bottom dashboard plane
  15. Click the disk icon towards the top left corner of the page and select Save to save the dashboard
  16. Click the My Content folder
  17. Name the dashboard and click the Save button
Was this article helpful?
Dislike 0