Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #126: Fill in the [Date] Gaps

JoeM
Alteryx Alumni (Retired)

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.

worldmapgif.gif

patrick_digan
17 - Castor
17 - Castor

Here's my solution

Spoiler
Capture.PNG
JoeM
Alteryx Alumni (Retired)

@patrick_digan. Pure unadulterated speed on that solution. 

patrick_digan
17 - Castor
17 - Castor

@JoeM My speed was a little slow last week for the first leg of the grand prix (I didn't finish it in under 12 minutes) so I tried to make up for it this week!

NicoleJohnson
ACE Emeritus
ACE Emeritus

My solution! 

 

PS. @patrick_digan, I agree, that was impressive. You must just sit with mouse at the ready, waiting for the next challenge to come out each week!!! Blazing fast!

 

Spoiler
WeeklyChallenge126.JPG

Cheers,

NJ

kat
12 - Quasar
Spoiler
Challenge #126.PNG
ggruccio
ACE Emeritus
ACE Emeritus

Everyone is very fast this week LOL!  Love the viz by the way @JoeM.

tcroberts
12 - Quasar

Here's my solution:

 

Spoiler
WC126workflow.PNG
Had some trouble with the Join until I realized that I only had one of each date (and not one for each country). At first I solved by adding a TextInput, but I the summarize makes it so that this workflow will still work if the input data changes.

Loved this challenge, really shows off some of the important steps in creating cool visualizations like the one above.

 

AGoyal
8 - Asteroid

There is an error in your question - it should start from 2017-10-01 (and not 10/1/2018).

 

Spoiler
alteryx-c126.PNG
Laurap1228
11 - Bolide

This was a fun one! I have to scaffold with dates frequently for work, so a very familiar topic.

 

Spoiler
Challenge126.PNG