Hello, Community! A solution to last week’s challenge can be found here. This challenge was created by Desmond Turner. Thanks, @Desmond , for submitting your idea for this Weekly Challenge! With the US football season now underway, it is the perfect time to dive into some football data. Over the years, the running back position in the National Football League (NFL) has seen a decline in value, driven by the league's shift towards a pass-heavy game. But does the data back this up? Use the provided dataset covering all plays from 2008 to 2019 to examine how the balance between running and passing has shifted over time. Your challenge is to complete the following tasks: * Calculate the total yards gained from run and pass plays each year. * Determine the percentage of total yards gained attributed to running plays. * Identify the top three teams that have leaned most heavily on the running game throughout this period. Good luck, and happy football season! Need a refresher? Review the following lessons in Academy to gear up. * Introduction to Macros in Designer * Types of Macros in Designer * Macro Interface Elements * Creating an Iterative Macro Source: https://www.kaggle.com/datasets/maxhorowitz/nflplaybyplay2009to2016?select=NFL+Play+by+Play+2009-2018+%28v5%29.csv Alteryx Academy Weekly Challenge_442_Start_file.yxzp Weekly Challenge_442_Solution_file.yxzp

my solution Challenge _442_solution.yxmd

Spoiler Weekly Challenge_442_Solution LF_file.yxmd

Spoiler Weekly Challenge_442_Solved.yxmd

Challenge #442: Examining the NFL's Shift from Run to Pass

Hello, Community!

A solution to last week’s challenge can be found here.

This challenge was created by Desmond Turner. Thanks, @Desmond , for submitting your idea for this Weekly Challenge!

With the US football season now underway, it is the perfect time to dive into some football data. Over the years, the running back position in the National Football League (NFL) has seen a decline in value, driven by the league's shift towards a pass-heavy game. But does the data back this up? Use the provided dataset covering all plays from 2008 to 2019 to examine how the balance between running and passing has shifted over time.

Your challenge is to complete the following tasks:

Calculate the total yards gained from run and pass plays each year.
Determine the percentage of total yards gained attributed to running plays.
Identify the top three teams that have leaned most heavily on the running game throughout this period.

Good luck, and happy football season!

Need a refresher? Review the following lessons in Academy to gear up.

Source: https://www.kaggle.com/datasets/maxhorowitz/nflplaybyplay2009to2016?select=NFL+Play+by+Play+2009-2018+%28v5%29.csv

Alteryx Academy

Weekly Challenge_442_Start_file.yxzp

Weekly Challenge_442_Solution_file.yxzp

Data Preparation

Core

Transform

Basic

Accepted answers

All comments

AkimasaKajitani

My solution.

Spoiler

Weekly Challenge_442_Start_file_AK.yxzp

Bobbyt23

Fun challenge.

Spoiler

giphy

Weekly Challenge 442 16-09-24.yxzp

Pilsner

My solution:

Spoiler

442 (NFL Play types).yxzp

Kenda

Spoiler

Weekly Challenge_442_Start_file.yxmd

shawn_jacob32

Spoiler

Weekly Challenge_442_Start_file_SJ32.yxmd

alacoume

My solution:

Spoiler

Weekly Challenge_442_Start_file.yxmd

RolandSchubert

Spoiler

weekly_challenge_442_solution_rsc.yxzp

fmilliren

Spoiler

Weekly Challenge_442_my_solution.yxmd

Flo_P

My solution

Spoiler

Challenge_442_Solved_FPER.yxzp

braveraj

Spoiler

Weekly Challenge_442_nfl_rushing.yxmd

mmontgomery

C442

Spoiler

c442.yxzp

RashedDS

Spoiler

Weekly Challenge_442_RashedDS.yxzp

nSpire

Spoiler

Weekly Challenge_442_nSpire.yxzp

jeprime

Spoiler

Great challenge. I initially attempted to simply group by season (March YYY to February YYY), then realized that the data was already separated and all games during Jan/Feb weren't in the data. That made it so much simpler.

JEP_442_Solution_file.yxmd

MelGibson

Not so much fun after the Cowboys lost 🙁 but here is my answer

Spoiler

MG Challenge 442 Solution.yxmd

patrick_digan

Spoiler

Weekly Challenge_442_Start_file.yxmd

Erin

Spoiler

Challenge_442_submission_EM.yxzp

ernesto_jackson

Attached is my solution for this week's challenge.

Weekly Challenge_442_Solution_EJ.yxzp

balajilolla2

Spoiler

Solution Attached
Screenshot 2024-09-16 140530.jpg

Weekly Challenge_442_Start_file.yxmd

olga_strubbe

Thank you, @Desmond!

It was a fun and timely challenge.

Weekly challenge 442_OS.yxmd

Hub119

LFG!

TB12 LFG.jpg

Weekly Challenge_442_CH Solved.yxzp

tammybrown_tds

Spoiler

Challenge_442_tbrown.yxmd

Qiu

Fun one.

Spoiler

Weekly Challenge_442_Start_file-Qiu.yxzp

Yoshiro_Fujimori

My solution.

Spoiler

As I am not familiar with Football terms, it took some time to get the meaning of "leaned most heavily on the running game".
My first interpretation was that the game is called "the running game" for the team,
when the count of "run" is greater than the count of "pass" for each team and each game. (like the third line of the workflow)

Workflow
Weekly Challenge_442_workflow.png