The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #3: Running Averages

Megan_HCC
7 - Meteor

This one was definitely a little more difficult than I expected, but glad I've completed it!

Albert_Vega
8 - Asteroid

Complete!

acarter881
12 - Quasar

Gonna go out on a limb and say this wasn't the most efficient solution.

Spoiler
my_weekly_challenge_3_solution.png
Brian32
8 - Asteroid

Challenge Solution

Spoiler
Brian32_0-1657895661295.png

 

James_Driver9
8 - Asteroid
Spoiler
James_Driver9_0-1658843329206.png

 

siddharth_28
8 - Asteroid

Re: Challenge #3: Running Averages

RMdL
7 - Meteor
Spoiler
RMdL_0-1660047464105.png

 

Oussaio
7 - Meteor

My Solution.

 

Spoiler
challenge_3_spoiler.png
Nicholas_White
8 - Asteroid

WOW

 

This one kicked my butt.

 

1. I didn't know what a 'running average' was to begin with, I need to go back to math school.

2. The strange acronyms for column names made it difficult to understand what was going on when transposing data.

 

For a workaround for myself, I renamed the columns with actual words (car brands and some sciency sounding words), and threw in some color-coded table graphics to help me make sense of what the Transpose and Cross Tab tools were doing. 

 

Spoiler
vitaminman12_0-1660717093883.png

 

Nick

ahsanaali
11 - Bolide
Spoiler
Spoiler
ahsanaali_0-1660922299014.png