Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #186: Drilling down into Data Analysis

Highlighted

Thanks for submitting, @Original_Yodies! My solution is similar to most of the others.

 

As others noted, the provided Answer doesn't match the first hint (it shows the Removed Date equal to the next installation date, not the day before). I made my solution match the Answer output.

 

Spoiler
challenge_186_workflow.PNG

 

 

Highlighted
Asteroid

Fun challenge!

Spoiler
Challenge_186_JWL.JPG
Highlighted
Meteor

Keep Smiling 

Highlighted
Alteryx Certified Partner

Here's my solution.

Thanks,

Chris

Highlighted
Asteroid

The key point of this issue is how to judge which period(install date ~ removed date) each Start Dtm belongs to. There are two solutions: 1) join each Start Dtm with every period on the same rig and filter out the correct period of each date; 2) generate one row for all the date during the period and join all data on date.

Spoiler
2019-11-16_184839.png2019-11-16_185710.png
Highlighted
Alteryx Partner

Challenge 186 is done!

 

Spoiler
image.png
Highlighted
Nebula
Nebula

Great change of pace - thanks for this challenge @Original_Yodies !

 

Spoiler
There are only 2 kinda interesting bits:
- The multi-row tool that puts an end-date on each install - this is a common pattern.
- The Generate Rows to create unique dates within the range to allow for the join


Solution.png

 
  

 

Highlighted
Bolide

My solution

Spoiler
Challenge 186.PNG
Highlighted
Asteroid
Spoiler
2019-11-26 07_33_15-Greenshot.png
Highlighted
Bolide
Bolide

Happy Thanksgiving!!!