From the course: Advanced Tableau for Climate Professionals
Unlock this course with a free trial
Join today to access over 24,900 courses taught by industry experts.
Challenge: Build CO₂ per capita and CO₂ per GDP KPI set
From the course: Advanced Tableau for Climate Professionals
Challenge: Build CO₂ per capita and CO₂ per GDP KPI set
(upbeat music) - [Instructor] In this challenge, we are going to create calculated fields for two important metrics, CO2 per Capita and CO2 per GDP. Step one, rename the fields. Rename CO2 per Capita to 3.1 CO2 per Capita, and CO2 per GDP to 4.1 CO2 per GDP. Step two, create all the logic for both metrics. You can copy and paste the logic shown in the title and no edits needed. Step three, organize your fields into folders. Once you're done, you'll have fully structural metrics set. Create the folders and organize them. Let's go ahead and build them now.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Build a base CO₂ emissions KPI for energy3m 8s
-
Fix latest CO₂ emissions using LOD expressions2m 53s
-
(Locked)
Enable dynamic year selection with parameters4m 4s
-
(Locked)
Calculate YoY change in CO₂ emissions3m 38s
-
(Locked)
Benchmark CO₂ emissions against income-group average5m 6s
-
(Locked)
Calculate each country’s global CO₂ share4m 34s
-
(Locked)
Compare CO₂ shares across two years5m
-
(Locked)
Compare CO₂ share with peer average5m 7s
-
(Locked)
Challenge: Build CO₂ per capita and CO₂ per GDP KPI set49s
-
(Locked)
Solution: Build CO₂ per capita and CO₂ per GDP KPI set3m 30s
-
-
-
-