Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #3: Running Averages

Highlighted
Meteoroid
Spoiler
Solution_Daniel_Challenge 3.png
Highlighted
Asteroid

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

 

Spoiler
Challenge_3_Mdodrajka.PNG

Highlighted
Alteryx Certified Partner

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)

 

Highlighted
Asteroid

Hi,

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

Spoiler
ShawnTM_0-1578587731855.png
Highlighted
Asteroid

 

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

 

 

temp003.PNG

 

Highlighted
Asteroid
 
Highlighted
Spoiler
Used the formula to the max on the multi row formula tool, but got it to be accurate!
Highlighted
Alteryx Certified Partner
Spoiler
edgarl_0-1579582590266.png
Highlighted
Meteoroid

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

Highlighted
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.