Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #142: Life Certainties - Workflows, Death, and Taxes

Highlighted
8 - Asteroid

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

Highlighted
11 - Bolide

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


Highlighted
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

Highlighted
6 - Meteoroid

Enjoyed this one

 

Spoiler
Challenge-142-solution.JPG
Highlighted
8 - Asteroid
 
Highlighted
5 - Atom

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

Highlighted
7 - Meteor

Took the "easy" route this time around

Highlighted
Alteryx Certified Partner

My solution (easy path though):

Spoiler
challenge 142.jpg
Highlighted
Alteryx
Alteryx

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

Highlighted
12 - Quasar

Solution attached.