Challenge #229: Trend Analysis

[RichoBsJ]

Hi! Here my solution 🙂

[TramT]

Enjoyed this one - have never had to manually calculate a trend line before.

A few minor cosmetic tweaks, and used the batch feature of the interactive chart tool for the first time.

Spoiler

[SamDesk]

Spoiler

Sam 🙂

[T_Willins]

I didn't want to combine or calculate the data twice, so I put the calculation into a standard macro.

Spoiler

[Jonathan-Sherman]

Challenge 229 is done, thanks @AngelosPachis for explaining the trend line equations!

Workflow:

Spoiler

Output:

Spoiler

[soha-elghany]

interesting challenge, I learnt a lot

[saideepuikey]

Enjoyed the challenge of formatting.

[JonathanAllenby]

Here's my solution and output.

Spoiler

[kelly_gilbert]

Interesting challenge - thanks @wwatson!

Spoiler

As others did, I recognized the formula as a least-squares regression line, so I also used the Linear Regression tool to generate the trend values. For this particular problem, the standard tools were much faster than the predictive tools.

Also, as others did, I packaged the chart creation in a macro, so it could be reused for multiple KPIs. Of course, in this case, there isn't a real business reason to let the user pick between predictive vs. standard tools, since they produce the same output! I just wanted to keep it all in one workflow, since the spirit of the challenge was to use standard tools. Plus, it's always good to get some practice with the Detour tools!

Macro:

Outer workflow:

 Output:

Spoiler

Truncated y-axis on an area-based chart is a pet peeve of mine, so, like many others, I chose to start both axes at zero 🙂 

[JethroChen]

Spoiler