Hi, Team Maveryx! A solution to last week’s challenge can be found here. It is that time again—the Superbowl is just around the corner! To get ready, grab your favorite snacks, call over some friends, and dive into some football stats. A big shoutout to Kenda Sanderson (@kenda) for bringing us this fantastic challenge! The Superbowl is about the best of the best! You will use the provided Fantasy Football dataset to determine which positions typically have the best rank and how that has changed over time. Complete the following tasks to solve this challenge: * Determine the five positions (POS) with the lowest overall rank (RK) for all years. * Create a line graph and a table that clearly show the fluctuation in rank over time, specifically for those five positions. Let's discover what fascinating insights you can extract from this challenge! If you need a little help, you can review these lessons in Academy: * Connecting to Multiple Sheets at Once * Changing Data Layouts * Multi-Row Formula * Reporting in Designer (all lessons) Source: https://fantasydata.com/nfl/fantasy-football-leaders?season=2018&seasontype=1&scope=1&subscope=1&startweek=1&endweek=1&aggregatescope=1&range=1 Challenge_412_start_file.yxzp Challenge_412_solution_file.yxzp

Here's my solution Challenge_412_solved.yxmd

My solution. Spoiler Challenge_412_solution.yxzp

Fun one, reporting tools are still tough to me. Challenge_412_start_file_mn.yxmd

Challenge #412: Superbowl Time —Lowest-Ranked Football Positions

Hi, Team Maveryx!

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

It is that time again—the Superbowl is just around the corner! To get ready, grab your favorite snacks, call over some friends, and dive into some football stats. A big shoutout to Kenda Sanderson (@kenda) for bringing us this fantastic challenge!

The Superbowl is about the best of the best! You will use the provided Fantasy Football dataset to determine which positions typically have the best rank and how that has changed over time.

Complete the following tasks to solve this challenge:

Determine the five positions (POS) with the lowest overall rank (RK) for all years.
Create a line graph and a table that clearly show the fluctuation in rank over time, specifically for those five positions.

Let's discover what fascinating insights you can extract from this challenge!

If you need a little help, you can review these lessons in Academy:

Source: https://fantasydata.com/nfl/fantasy-football-leaders?season=2018&seasontype=1&scope=1&subscope=1&startweek=1&endweek=1&aggregatescope=1&range=1

AYX-Maveryx_Micro Identity-Maveryx Academy_wordmark.png

Challenge_412_start_file.yxzp

Challenge_412_solution_file.yxzp

Data Analysis

Intermediate

Data Preparation

Core

Accepted answers

All comments

Kenda

Thanks @AYXAcademy

I can't wait to see how you all approach this challenge. I'll be cheering on my high school classmate Drue Tranquill and the Chiefs this weekend!

philipmannering

Thanks @Kenda

Spoiler

Challenge_412_start_file.yxmd

ggruccio

Fun football challenge!

Spoiler

Had to use dynamic input and make sure to bring in and parse out the Year --- then work with Interactive Chart Tool.

Challenge_412_gg_finish.yxzp

RolandSchubert

Spoiler

Challenge_412_solution_rsc.yxzp

alexnajm

Fun challenge!

Spoiler

Challenge_412_start_file_Alex Abi-Najm.yxzp

ed_hayter

Still waiting on a Super Bowl Party Invite

Spoiler

Challenge_412_start_file.yxzp

balajilolla2

Spoiler

Challenge_412_start_file.yxmd

K_Vinogradov

That was a fun challenge! Thank you @Kenda!

Spoiler

Challenge_412_Solution.yxmd

mmontgomery

C412

Spoiler

c412.yxzp

FrederikE

Quick and dirty,

Spoiler

C412.yxzp

DataNath

My solution to #412.

Spoiler

Challenge 412 completed.yxmd

Powerhouse_21

Spoiler

PH21_Challenge_412.yxmd

toby49

Spoiler

Challenge 412.yxzp

NRoland

Spoiler

Challenge_412_Nroland.yxzp

Kenda

Spoiler

my take

Challenge_412_ks.yxzp

Watermark

Spoiler

Challenge_412_MT_Solution.yxmd

a640687

Spoiler

Challenge_412_start_file.yxmd

emmaob98

Spoiler

Challenge_412_EO.yxmd

braveraj

I ended up cleaning up the formatting of the spreadsheets. Perhaps I used one too many tools.

Spoiler

Challenge_412_fantasy_football_rank.yxmd

logdog0411

Spoiler

Here's the problem: Higher numbers are lower ranks. (I.E. 1 is best, 2, 3, and so on)

So the results shown are the 5 HIGHEST ranked positions, not the lowest. If I wanted to sort for the lowest ranked positions (I chose not to because I'm lazy) I would change the Sort tool in the middle to Descending vice Ascending. This changes the 5 positions to CB, DB, FS, NT and S.

(Football nerd question: If we have a CB, FS, and S category, why is there a catch-all DB category???)

Also the Y-axis on the line chart should be reversed - best ranks (lowest numbers) at the top.

It took me some searching to figure out that to do this, you have to reverse the max and min in the "Axes" menu in the Interactive chart tool

I color coded for my beloved Browns (shoutout @ggruccio!) on the table and some different formatting for the line graph to make it pop a little.

I embedded my output pdf as well as a photo of my favorite player, Nick Chubb.

Nick was ranked #17 in 2022, BTW 🏈🟠🟤

Go Browns!

Challenge_412_Bellamy.yxzp

nSpire

Spoiler

Challenge_412_nSpire.yxzp

nhardin

Spoiler

Challenge_412_Solution_NH.yxmd

AkimasaKajitani

My solution!

Spoiler

Challenge_412_start_file_AK.yxzp

TurboToad

Fun, creative challenge!

Spoiler

TT_Challenge_412_solution_file.yxmd

Qiu

@Kenda
Nice weekly challenge. Thanks.
Wondering why not the "Highest" rank though. 😁

Spoiler

Challenge_412_start_file-Qiu.yxzp

alacoume

My solution:

Spoiler

Challenge_412_start_file.yxmd

RWvanLeeuwen

I always overspend time trying to make something visual in Alteyrx, but then again, I seem to have enough time on my hands to do so... Keep those challenges coming people!