Free Trial

Cloud Quests

Elevate your workflow skills by solving real-world challenges using the Alteryx Analytics Cloud Platform.

Cloud Quest #15: Formulate Fantasy Football Place Kicker Points

AYXAcademy
Alteryx
Alteryx

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!

 

  1. Download the provided JSON file containing your starting data and workflow files.
  2. Upload the provided Cloud Quest 15 Start.json file into your Analytics Cloud library.
  3. 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:

 

  1. 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.
  2. 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.
  3. 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.

 

Spoiler
A combination of the Summarize, Join, Transpose, Sample, and Formula tools should solve your problem, but not necessarily in this sequence.

 

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.

  • 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!

AYX-Maveryx_Micro Identity-Maveryx Academy_wordmark.png

 

 

 

10 REPLIES 10
patrick_digan
17 - Castor
17 - Castor
Spoiler
image.png
alexnajm
17 - Castor
17 - Castor

Done!

Spoiler
Quest #15 screenshot.png
Qiu
21 - Polaris
21 - Polaris

I was not clear about the definition about "Average Point" and "Top 5",
Had to refer to the solution posted. 😂

Spoiler
Cloud Quest 15.png
AkimasaKajitani
17 - Castor
17 - Castor

My solution!

 

Spoiler
スクリーンショット 2024-08-24 002345.png

ggruccio
ACE Emeritus
ACE Emeritus

Fun football challenge!

 

Spoiler
Screenshot 2024-08-23 133228.png
AnnaELawrence
Alteryx
Alteryx

Fun! 

Spoiler
 

2024-08-28_15-08-20.jpg

 

JeffF
Alteryx
Alteryx
Spoiler
Quest15_JeffF.png
geoff_zath
Alteryx
Alteryx
Spoiler
quest_15_workflow.png

RWvanLeeuwen
11 - Bolide

another quest completed (except the PAT which was not understood by me)

Spoiler
quest 15.png