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.

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

KaneG
Alteryx
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.



KaneG_2-1603328313393.png

 


 

KaneG_1-1603328223270.png

 

ArtApa
Alteryx
Alteryx

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

 

Spoiler
ArtApa_0-1603345759917.png

 

kelvinlaw
8 - Asteroid

Here is the solution:

Spoiler
kelvinlaw_0-1603350792033.png

Analytic App Input with Result:

kelvinlaw_1-1603350919637.png

Error for not selecting 3 checkboxes:

kelvinlaw_2-1603350981700.png

 

 

hanykowska
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
238_app_in_action.gif

Workflow:

Spoiler
hanykowska_0-1603352092582.png

 

mbogusz
8 - Asteroid
Spoiler
2020-10-22 08_18_46-Greenshot.png
Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 238 is done!

 

Spoiler
Jonathan-Sherman_0-1603391540498.png

 

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

T_Willins
13 - Pulsar
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
Workflow 238.jpg

 

ConradW
8 - Asteroid

Back on the challenges

JustinBabbitt
10 - Fireball

Apps and Error messages are fun! 

Spoiler
JustinBabbitt_0-1603720485225.png