Cloud Quest #15: Formulate Fantasy Football Place Kicker Points
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Maveryx,
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!
Let’s dive into this week's quest!
- Download the provided JSON file containing your starting data and workflow files.
- Upload the provided Cloud Quest 15 Start.json file into your Analytics Cloud library.
- All necessary datasets are contained within Text Input tools in the workflow.
For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process Update.
Scenario:
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:
- Determine the difference in points scored for each kicker from the old calculation method to the new calculation method. Then calculate the average change in points scored by all kickers. Round the average point difference to tenths of a point.
- List the top five kickers, their pro teams, their points using the old method, their points using the new method, and the difference in points the new rules would have on their total fantasy points.
- Solve the bonus question. The points after touchdown (PAT) from 2023 have also been included in a third Text Input tool. As a bonus question, use this data to calculate the total points earned for each kicker and list the top five kickers calculated with the old rules and new rules.
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:
- Getting Started with Designer Cloud
- Building Connections in Designer Cloud
- Building Your Workflow in Designer Cloud
Once you have completed your quest, go back to your Analytics Cloud library.
- Download your workflow solution file.
- Include your JSON file and a screenshot of your workflow as attachments to your comment.
Here’s to a successful quest!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Done!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I was not clear about the definition about "Average Point" and "Top 5",
Had to refer to the solution posted. 😂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
another quest completed (except the PAT which was not understood by me)