community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #3: Running Averages

Meteoroid

A little tricky due to NULL values and not grouping by month and year.


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

Asteroid

my solution

 

first time using imputation tool!


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

Asteroid

I was confused by the moving average example given in instructions...the three numbers given divide by 3 does not equal the moving average supplied as the example answer.

 

Month: Value: Running 3 mo. Average:
1 218 218
2 200 212
3 272 233

 

218+200+272 = 690 / 3 = 230 (not 233)

 

I am fairly pleased with my answer from an eloquence perspective. Would love for someone to give it a look over, but seems to be producing the correct output.

 

Originally was doing multiple multi-row formulas, but the transpose then cross tab approach worked pretty well.


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

Meteor

Good intro to multi-row/group by tool.


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

Meteoroid

My solution to number 3.  Two joins at the end for clarity of flow.  


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

Bolide

Finally posting some of my solutions! This was a really fun one! 

Spoiler

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

Highlighted
Alteryx Partner

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

Atom

Hi,

Below is my solution for Challenge 3.

Cheers,

IP


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

Alteryx Partner

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


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