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 #229: Trend Analysis

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found herepptimage.PNG

 

This week's challenge was submitted by @wwatson  - Thanks for your submission!

 

Two sets of performance data are provided below. Plot that data on bar charts, calculate a trendline for each graph, and export the charts to a single Powerpoint slide.

 

The method for calculating the trend line can be found on various websites. The author used this one.

Aaron_Harter
11 - Bolide

Not your average challenge!

Spoiler
1.PNG

(edit 8/17 9:53 CT) video of solution overview:

Spoiler

The trend line calculation was driven by the core logic from this Macro in the gallery - https://gallery.alteryx.com/#!app/Least-Squares-Regression--Slope--Intercept-/5ab4ff0f8a9337138c471a...

dsmdavid
11 - Bolide

Not Base Alteryx compliant, but...

Spoiler
dsmdavid_0-1597671895697.png

 

johnemery
11 - Bolide

Fun challenge. A good one, too, for those who aren't well-versed in linear regression: this is how it's done!

But tisk tisk tisk; shame on you Alteryx for truncating the y-axes on your output charts.

 

Spoiler
Workflow Capture.PNGPPT Capture.PNG

 Check out my solution video below:

Spoiler
Blake
12 - Quasar

229 done!

 

Spoiler
229.png
atcodedog05
22 - Nova
22 - Nova

@Aaron_Harter Great to know about the macro.

wwatson
12 - Quasar

Extra points for those not using the macro though 🙂

atcodedog05
22 - Nova
22 - Nova

Was a great exposure : )

 

Thank you for this great challenge @wwatson 

 

I followed the steps from the website given in the challenge description.

 

Spoiler
 
atcodedog05_0-1597676192888.png

 

Cheers and Happy analyzing : )

 

 

patrick_digan
17 - Castor
17 - Castor
Spoiler
patrick_digan_0-1597676203379.png

 

jasperlch
12 - Quasar
Spoiler
Capture.PNG