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.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.
alteryx Community

# Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

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

Submit Feedback

## Challenge #271: Dynamic Double Dip

Alteryx

A solution to last week's challenge can be found here

If you're familiar with the Formula tool in Designer, you know that there aren't many things you can't do with it. But just because you can do something doesn't mean that you should. There are some tasks that can get a little repetitive when you have to do them over and over again. In those instances it can be more efficient to think about ways to make the process a little more dynamic. This also serves you well as you begin automating processes because it can keep workflows from breaking when datasets change.

For this week's challenge, we want to perform a simple calculation: divide each month's Tax value by its Cost value to find the Percentage. Since there are almost always multiple ways to accomplish the same task, go for a double dip and find two solutions to arrive at the final output.

11 - Bolide

Fun challenge to start the week!

Spoiler
12 - Quasar

You should never double dip a chip. Alteryx solutions, sure. Never a chip.

Spoiler

11 - Bolide
Spoiler
I think it's probably the first time I use "Arrange" in a weekly challenge 😅

11 - Bolide
Spoiler
#271

Alteryx

Enjoyed the challenge, had to put in some creative thought to find another way!

Here are my solutions!

Spoiler

15 - Aurora

My solution(s).

Spoiler
13 - Pulsar
Spoiler

9 - Comet

Double-dipping can be acceptable in some cases...? ¯\_(ツ)_/¯

Spoiler

16 - Nebula

I have a standard solve and then I have a whiz-bang macro that is perfectly built for a use case like this

Spoiler
My standard solve uses transpose-crosstab, which is a common design pattern ( @joshuaburkhow @cgoodman3 )

My macro solve uses my multi-row multi-field tool, which combines the multi-row and multi-field tools. It's extremely quirky, but it is pretty powerful once you learn how to harness it. In this use case, it gives you the ability to reference 1 column to the left. I also used the field sort which is a cool Crew Macro.