Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

AngelosPachis
16 - Nebula

Challenge #229 is done. I truncated the axes just to much the solution, but this is not considered to be best practice

 

Main Workflow : 

 

Spoiler
Annotation 2020-08-22 100157.png

Trend Line Macro :

 

Spoiler
Annotation 2020-08-22 095145.png

Performance Chart : 

 

Spoiler
Annotation 2020-08-22 100613.png

  

pirroav
6 - Meteoroid

Hey All!

 

Long time user but this is my first time "turning in" a challenge. This was fun! 

RWvanLeeuwen
11 - Bolide

I expect this will not be part of the Expert Exam, as  it is quite trivial and mostly irrelevant

 

Spoiler
229 result.jpg

Above is the result and below is the workflow

 

Spoiler
229 workflow.jpg
randreag
11 - Bolide

Here my solution!

KaneG
Alteryx Alumni (Retired)

That required more prep than I thought...

 

Spoiler

Initially I mucked up values and so reverted to calling the fieldnames exactly what they were in the formula... I had never used the option in the interactive chart to show the points as well as the line.

KaneG_0-1598502787630.png

 

CKent
6 - Meteoroid

Love the combo of Maths and Reporting tools in this one!

allwynthomas24
11 - Bolide

That was a great one. Thank you @Alteryx & @wwatson for this lovely challenge.


Got to get my hands on interactive charts and also got an idea about Linear Regression.

 

 Formula Reference.

Trend Line Formula.PNG

 

Spoiler
Workflow

challenge_229_solution_Allwyn_Thomas_Spoiler.PNG

 

 

Spoiler
Output Saved in 

challenge_229_solution_Allwyn_Thomas_Output.PNG

 

Do like and share my answer.

✌ Thanks & Peace Out ✌

 

mbogusz
9 - Comet
Spoiler
2020-08-31 08_05_10-Greenshot.pngEngine_18192_09fbd4affc414f83b61f6590a417351e_.png
Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !

JP_SDAK
8 - Asteroid

This took awhile, as I had to learn the report tools, but was great experience.  I calculated slope and equation using link in description.

Spoiler
challenge_229.JPGchallenge_229_charts.JPG