We posted the solution JSON file to Cloud Quest #14. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!
For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process Update.
Fantasy Football season is almost upon us in the US so there is no better time than now to evaluate how well kickers perform. This year, Yahoo! Fantasy Football has introduced a new wrinkle into how place kicker scoring is calculated.
In previous years, field goal points were earned based on the distance of the field goal, but only in ranges: 0–39 yards = 3 points, 40–49 yards = 4 points, and 50 or more yards = 5 points.
In 2024, a new method has been introduced that gives 0.1 points per yard for each successful field goal attempt, meaning: a 25-yard field goal will be worth 2.5 points, a 33-yard field goal will be worth 3.3 points, a 56-yard field goal will worth 5.6 points, and so on.
A list of kickers who are on current NFL rosters has been provided in the NFL Kickers Text Input tool. The 2023 Field Goals Text Input tool contains the distances of each field goal they kicked per week last season. The objective of this Cloud Quest is to:
Hint: To answer Tasks 1 and 2, remove Null records. To answer the Task 3 bonus question, replace Nulls with 0.
If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in Maveryx Academy for guidance:
Once you have completed your quest, go back to your Analytics Cloud library.
Done!
I was not clear about the definition about "Average Point" and "Top 5",
Had to refer to the solution posted. 😂