alteryx Community

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

## Challenge #229: Trend Analysis

Alteryx

A solution to last week’s challenge can be found here

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.

11 - Bolide

Spoiler

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

11 - Bolide

Not Base Alteryx compliant, but...

Spoiler

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

Check out my solution video below:

Spoiler
12 - Quasar

229 done!

Spoiler
22 - Nova

@Aaron_Harter Great to know about the macro.

12 - Quasar

Extra points for those not using the macro though 🙂

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

Cheers and Happy analyzing : )

17 - Castor
Spoiler

12 - Quasar
Spoiler