We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
In this week's challenge, we are trying to prep our data for a time lapse visualization of certification exams passed in each country. In order to achieve this visualization, we have to make sure that each country has a running total for every day between 10/1/2018 and today (datetimenow). However, we only have dates for when a certificate was earned by each country. For each country, add in all the date gaps, calculate a running totals and update the running totals to report '0' for a running total in time before the first exam was passed.
Here's my solution:
Loved this challenge, really shows off some of the important steps in creating cool visualizations like the one above.