Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

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

Inactive User
Non applicable

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

AndrewS
Bolide

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

jon_m_nakamoto
Météoroïde
brute force, inelegant solution. But it seems to work. I don't understand why the posted solution pivoted/denormalized the data -- didn't see anything in the instructions that this was the way to present the data. For some reason I can't attach the solution. But it was boring anyway (12 consecutive Multi-Row formulas).

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

Benbryans
Astéroïde

got there in the end!


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

JessieB
Météoroïde

Unfortunately a tedious solution to this problem while I learn more efficient ways of using the tool, but didn't take long to compile.


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

Chantelb
Comète

Fun challenge! Love the multi-row tool


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

mbogusz
Comète
Spoiler

Running Averages with the Multi-Row Formula tool. That was fun. 


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

ArnavS
Alteryx Alumni (Retired)

Great way to learn the difference between Transpose and Crosstab


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

danicahui
Astéroïde

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.