Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
alteryx Community

# 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.

## Challenge #238: Ideal Gases Don't Exist

Alteryx Alumni (Retired)

I can imagine there are a bunch of different solutions to this one. I'm normally not that concerned about using too many tools, but this one required more interface tools than non-interface. It'll be interesting to see how many different ways people lay out their interface tools!

Spoiler
I went with a simple way of selecting which variable to calculate... use another input. It makes the formulas easier I think. Error message is handy and I'm sure there's a solution similar to (ToNumber([#1]) + ToNumber([#2]) + ToNumber([#3]) + ToNumber([#4])!=3). I left my IIF replace formula solution as it worked without having to troubleshoot the ToNumber.

Alteryx

This is the first time I've built a one-tool-solution to a Weekly Challenge:

Spoiler

9 - Comet

Here is the solution:

Spoiler

Analytic App Input with Result:

Error for not selecting 3 checkboxes:

11 - Bolide

Learned a few things in the process, thanks!

I was considering making a flexible solution that would be easy to adapt for other calculations, but decided against it and went for a quick win 😅

Output:

Spoiler

Workflow:

Spoiler

9 - Comet
Spoiler
15 - Aurora

Challenge 238 is done!

Spoiler

9 - Comet
Spoiler
It looks like there's an error but it runs fine in the app 🙂

14 - Magnetar

Instead of adding the error I went the the preventative control:  Let the user select the calculated variable and let them know the amount in the selected variable input will be ignored for the calculation.  The Error Message tool is useful, but I would rather make the workflow error proof instead.

Spoiler

8 - Asteroid

Back on the challenges

Alteryx

Apps and Error messages are fun!

Spoiler

Justin Babbitt