Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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

NS4
7 - Meteor

Interesting one

Spoiler
Challenge 229.PNG

Sashikumar
8 - Asteroid

Good to work with calculation stuffs.ch229.PNGch229_1.PNG

Verakso
11 - Bolide

Thanks to @wwatson for a fun challenge.

 

I will for sure, think about the math behind, next time I just add a trendline in a Viz tool.

 

Spoiler
This is how my challenge ended up, I thought as others to use Python or take a different approach, but sometimes plain calculation and interstation can work out as well
The WorkflowThe Workflow

 
I think my result did match the provided PowerPoint, but I am still struggling with the Alteryx Report Tools, since I find them a bit tricky.
The PowerpointThe Powerpoint

 

Still Climbing
/Verakso

jiachern
6 - Meteoroid

Pretty fun one to do

 

jiachern_0-1597762423032.png

jiachern_1-1597762459805.png

 

 

JoshuaGostick
11 - Bolide

My solution

 

Spoiler
challenge_229.PNG
LittleE
8 - Asteroid

I purposefully did not rescale the bar charts to agree with the example, because that is bad practice for bar charts.

Spoiler
LittleE_0-1597781137883.png

 

kelvin_law1
9 - Comet

Here is my solution:

Spoiler
kelvinlaw_0-1597803738681.png

 

kelvinlaw_1-1597803781979.png

 

Ladarthure
14 - Magnetar
14 - Magnetar

lovely challenge! a bit of math in the morning!

AhmadAlkherbawy
7 - Meteor

Nice one.

Spoiler
solution.png

Macro:

solution-macro.png 

 

dkoenawan004
7 - Meteor

My solution to the challenge. 

 

I don't use the reporting tools suite too much, so this challenge is a great refresher (as evident by the liberal use of the browse tool).

 

Spoiler
dkoenawan004_0-1597824587727.png