Week 32: Coloring Between the Lines

August Community Submission Month

Welcome to community submission month. For all 5 of those weeks we’ll have our favorite community submissions as challenges. FYI: You can still submit here.


Community Submission Challenge #2: Rosario Irasema Gauna González

Our second community challenge comes from Rosario Irasema Gauna González. Rosario is located in Monterrey, Nuevo León in Mexico. She is the Director of Analysis at Information at the University of Tecnológico de Monterrey. She also a Tableau Public Ambassador and blogs at Rosarioviz. Don’t forget to follow her on twitter. With that, here is Rosario:

The goal of this week’s challenge is to better understand

click to view on Tableau Public


  • Dashboard size: 800 x 700.
  • Use per capita calculations.
  • You must be able to select data from a specific country or the world itself.
  • You must be able to select between Ecological FootPrint Production and Ecological FootPrint Consumption.
  • The green line should be biological capacity per capita.
  • The red line should be ecological footprint per capita.
  • If the Biological Capacity is greater than the Ecological Footprint, it means that we have a positive reserve and the area between the two lines must be shaded in green.
  • In the opposite case, it means that there is a deficit and the area between the two lines must be shaded in red.
  • When you move the cursor over the graph subtitles should update to the selected year.
  • When you move the cursor over the graph the subtitle of the difference between Capacity and Ecological Footprint should be green if there is a reserve (+) or red if there is a deficit (-) in the year.
  • Rebuild everything to look identical. Make sure you match titles, tooltips, etc.



This week uses the Biocapacity vs. Ecological Footprint dataset.  You can get it here at data.world



After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday and tag @AnnUJackson, @LukeStanke, @RodyZakovich, and our community contributor @rosariogaunag.  (Tag @VizWizBI too – he would REALLY love to see your work!)


Track your progress

Also, don’t forget to track your progress using this Workout Wednesday form.


2 thoughts on “Week 32: Coloring Between the Lines”

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top