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

realdaniel1989
8 - Asteroid
Spoiler
Solution_Daniel_Challenge 3.png
mdodrajka
8 - Asteroid

Quite an interesting one. Tweaked the Output format slightly in my 3rd solution for intuitive view.

 

Spoiler
Challenge_3_Mdodrajka.PNG

RWvanLeeuwen
11 - Bolide

Again my solution.

 

Spoiler
Sorry, no image for this one



I thought I had submitted my solution, but when I ran the workflows from the index (next) this one was still empty somehow
         Download this workflow created by @ Hannah_Lissama, @ Alekh, and @ mceleavey.
          or try this app to download your unsolved challenges. (Created by: @ LordNeilLord)

 

ShawnTM
8 - Asteroid

Hi,

Here's is my solution. It doesn't quiet match the output

Spoiler
ShawnTM_0-1578587731855.png
terry10
11 - Bolide

 

The dynamic renames in the posted solution aren't working as intended.

 

 

temp003.PNG

 

terry10
11 - Bolide
 
KellyAloha
5 - Atom
Spoiler
Used the formula to the max on the multi row formula tool, but got it to be accurate!
edgarl
8 - Asteroid
Spoiler
edgarl_0-1579582590266.png
Per
11 - Bolide

Yes, the Output does not make sense for this Challenge. The first line have an average of "10 rm" which is clearly wrong.

mikeprice17
8 - Asteroid

I ended up transposing the data, tiling it by Record number, using a multirow formula and then unioning all fields to get a matching dataset. My naming convention was slightly different as well.