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

mgaronson
11 - Bolide
Spoiler
mgaronson_0-1675529890758.png
Got to use Running Totals! I usually forget about this tool and use the multi-row formula tool. Running totals was perfect for this challenge.
kristiadiuisan
8 - Asteroid
Spoiler
Alteryx_challenge_126_KU.png
leonhekkert
8 - Asteroid

My solution:

 

Spoiler
Challenge_126.png

 

dougbaron
8 - Asteroid
Spoiler
dougbaron_0-1679343964008.png

 

CeliaC_Silje
8 - Asteroid
Spoiler
CeliaC_Silje_0-1679988930545.png
alacoume
8 - Asteroid

A solution:

DataNath
17 - Castor

My solution to #126.

 

Spoiler
DataNath_0-1682247241203.png
ed_hayter
12 - Quasar
Spoiler
ed_hayter_0-1684173632544.png

couldn't get the numbers to match up perfectly. But the logic seems to be there.
from the comments I think it comes from needing to generate rows from this start date provided by a comment: 2017-10-01

chandler-gjino
Alteryx
Alteryx

attaching my solution

MitchellBliesner
8 - Asteroid

Here is my solution to the challenge