Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEASolution attached
This one was fun, and super interesting to think through! My solution is similar to many others, except I added workflow constants for the work-from-home days, temperature threshold, and distances (to make it easy to change those if Marie moves, changes her schedule, or changes her weather preference!
I am cold intolerant, so I would have to add a lower threshold for my biking days (e.g. drive if it is < 8C or > 28C)!
Problem: there is one null value in one record of max temp, no directions on how to deal with that. (up to user), and the problem says she'll drive when temp gets to 28 degrees. This is technically ambiguous but will assume this means when it gets to 28 or below, she drives.
I believe the output in the initial file provided is showing days biked when its below 28 (which doesnt really make sense). Anyways, it was a great practice problem.
My solution