Challenge #229: Trend Analysis

[abrouwer]

See the solution attached.

[balajilolla]

Spoiler

Solution Attached

[paulfound]

Spoiler

 Bit repetitive could join them together i guess to make more slim-lined or make into a macro :S

[mustel]

Am I really the only one who cheated and used the linear regression model!?!

Spoiler

Also, shame the Visual Layout (beta) doesn't allow you to centre an object yet...

[dlopez13]

Certainly makes you appreciate the Linear Regression predictive tool macro!

Spoiler

[mustel]

And now my "hack" is completely dynamic 🙂

Spoiler

Just had an idea to utilise the score tool instead of using the coefficients in a formula

[Tony_Castillo]

Spoiler

[Qiu]

I am not sure this challenge shows the power of Alteryx since the simple Excel can do the same.
Though I practiced the Macro and Reporting tools, which is good for me.

Spoiler

[jeng]

Spoiler

Doing the math inside a macro:

Using it to get the individual trendlines, apply chart formatting and assemble output:

[JennyMartin]

Spoiler

Great challenge for dusting off stats skills and the reporting tools. Video solution here: https://www.youtube.com/watch?v=xiWW54PIqBo&list=PL18SpOXDj-KMUD4YwWC5vZaUsIa7drxNZ&index=34&t=0s