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.
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 #238: Ideal Gases Don't Exist

Alteryx

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

8 - Asteroid

Here is the solution:

Spoiler

Analytic App Input with Result:

Error for not selecting 3 checkboxes:

10 - Fireball

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

8 - Asteroid
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 🙂

13 - Pulsar

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

10 - Fireball

Apps and Error messages are fun!

Spoiler