Free Trial

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