Weekly Challenge

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #126: Fill in the [Date] Gaps

Highlighted
8 - Asteroid

I could definitely cut some tools out after looking at other solutions, particularly in generating rows from 2017-10-01. My solution attached. Fun challenge! 

Highlighted
8 - Asteroid
 
Alteryx Partner

My solution to this week's challenge is attached.

Highlighted
8 - Asteroid

Generated dates for the first time.

Highlighted
8 - Asteroid

Very interesting challenge!

Highlighted
16 - Nebula
16 - Nebula

Wanted to do this one a little differently than the approach taken by @patrick_digan and @NicoleJohnson - so used one of the TimeSeries tools.

 

BTW: @JoeM - the question text may need alteration - it should start from 2017-10-01 (not 10 Jan 2018) to match the sample output ( @AGoyal was the first to spot this).

 

Spoiler

I went around this a different way than the Generate Rows solution:
- Get a unique list of countries
- Then get a unique list of dates; adding on the boundary dates (01 Oct 2017; and today's date).    To complete this list - use the date-time filler tool to fill any gaps.
- then do a cartesian join using the append tool
- then sum up the existing and the new rows to get the final answer.

2018-09-10_6-43-37.jpg
2018-09-10_6-45-03.jpg



 

Highlighted
Alteryx Certified Partner

Here's my solution. A pity TS Filler can't be grouped or this would've taken fewer tools.

 

Spoiler
Screenshot 2018-09-10 at 23.07.09.png
Highlighted
7 - Meteor

Here's my solution

Highlighted
7 - Meteor

I do not normally use generate rows, so this was a great challenge to try new tools! Add one more to the tool belt! 

Highlighted
7 - Meteor
Spoiler
challenge_126_ShokatAli.PNG