#WorkoutWednesday challenge this week was set by @rosariogaunag and it was about coloring between the lines. Here in this viz challenge, we are going to use Area charts to showcase different colors based the lines along with it has dynamic text + values on dashboard on hover. I like how it covers small things which improves the visualization and makes it tempting & simple for user to understand.
Requirements:
- 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.
Data for the workout can be downloaded from here
Here is my output for the challenge (Click on gif for interactive version):
Let me share the steps required to create this visualisation post data is imported into Tableau:
Step 1: Create Parameter to select the type of Ecological footprint “Select EF”
Step 2: Lets create all the necessary calculated fields which we will use in the visualisation
BioCap – This field to derive biological capacity values from the dataset
EcoFootPrint – This field to derive Ecological footprint based on parameter “Select EF”
For the display the color between the lines following calculated fields we need:
Green: To create an area where difference between Biological capacity and Ecological footprint is positive else 0 as value
Red: To create an area where different between Ecological footprint and Biological capacity is positive else 0 as value
White: To create an area where whichever is minimum of biological capacity or ecological footprint is selected as value
Diff: Difference between Biological capacity and Ecological capacity
Display: Label field to show Reserve or deficit based on “Diff” value
Color: Binary field to show different color for “Diff” Value
Step 3: Create First sheet “BioCap”
Drag “Biocap” and “Record” Field to Text area
Drag “country” field to filters then set it to apply for all worksheets using this source and show filters with single dropdown
Drag “Record” field to filters and select Biological capacity as filter
Format the Text based on requirement and arrange them as per following image
Step 4: Create “EcoFootPrint” Sheet
Drag “EcoFootPrint” and “Record” Field to Text area then you will country filter automatically appearing in filters
Drag “Record” field to filters, go to condition tab then select “By Formula” and enter “[Record]= [Select EF]”
Format the text based on requirement and arrange them as per following image:
Step 5: Create “Diff” Sheet
Drag “Diff” and “Display” field to Text and “Color” field to color in marks area then allocate Green color for True and Red for False value
Format the text based on requirement and arrange them as per following image:
Step 6: Create “LineGraph” Sheet
Drag “Year” into column shelf followed by drag “Measure values” into Rows shelf then filter the field by selecting “Red”, “Green” and “White”
Change the chart type to “Area” Chart
Drag “Measure Names” to color shelf and allocate respective color based on field name and we will see following output:
Now drag “Total” field to rows shelf and change the chart into dual axis then select “Line” chart from the Marks area
Drag “Record” field to color shelf and filter shelf then go conditions and apply following formula “Record]=”BiocapPerCap” OR
[Record]= [Select EF]”
Also, change the color for Biological capacity to Green and Ecological footprint to Red for both options of parameter
Step 7: Create “Subtitle” sheet
Drag “Country” and “Year” field to Text area and drag “color” field to color shelf and apply red and green value for true and false value respectively.
Step 8: Create the Dashboard
Now time comes to create the magic, arrange all the sheets into dashboard and set the size of dashboard as 800 * 700 to look like this:
Then we need to do create action filter on hover, so select Dashboard –> Action –> add action -filter and set the filter on all sheet on the basis of Year
Now do the final aesthetic changes like formatting and tooltips to get the final output as per our requirement
we are ready with final visualization as show above.
Thanks Rosario Gauna for this workout.
Happy Data Visualisation!!!!
Thanks for visiting this post. Please do let me know your feedback or if you have any questions about the blog do not hesitate to contact me on twitter (@Desaimithun)
Do subscribe to Tabvizexplorer.com to keep receive regular updates.
Creative idea Mithun, thanks for the post!
Thanks 🙂