community
cancel
Showing results for 
Search instead for 
Did you mean: 

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 #142: Life Certainties - Workflows, Death, and Taxes

Asteroid

This one gave me a headache! think i started out in the wrong direction and took a very long route around

Workflow attached for both the easy way and hard way. My solutions for both are pretty similar to others up-thread!

 

Spoiler
Easy way workflow:
challenge_142_easy_way_workflow.PNG
Spoiler

For the "hard way," I appended the whole tax table to each employee row, then filtered and summarized to pick the appropriate bracket.

After looking through some of the other soutions, I learned about the Dynamic Replace tool. I had never heard of that tool before, so that will be pretty useful in the future!


Hard way workflow:
challenge_142_hard_way_workflow.PNG


Hard way macro:
challenge_142_macro.PNG


Alteryx Certified Partner
Spoiler
Capture.PNG

The first weekly challenge I was able to complete in full! Took a few hours, but, Practice makes perfect! 

 

I have some more detail in my final answer as I don't want to ignore some "taxing" variables.

 

I know I can clean up the workflow a little, so if anyone has some suggestions, leave a reply!

 

Cheers,

 

Cameron

Meteoroid

Enjoyed this one

 

Spoiler
Challenge-142-solution.JPG
Asteroid
 
Atom

My first weekly challenge, not a very elegant solution but it works. 

Meteor

Took the "easy" route this time around

Alteryx Certified Partner

My solution (easy path though):

Spoiler
challenge 142.jpg
Alteryx
Alteryx

I took the easy and slightly longer road! Made of the Total Column in Cross Tab to finish it off!

Quasar

Solution attached.