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 #386: Shed Light on a Bank’s Risky Business

5 - Atom

If you end up replacing that empty high value with a number like "999999999999" have a look at this one. It's unlikely that such a value is ever reached but you can never be 100% certain :)

Spoiler
IF [Value] > [Amber Low] and [Value] <= [Amber High]
THEN 'Amber'
ELSEIF [Value] > [Green Low] and ([Value] <= [Green High] OR IsNull([Green High]))
THEN 'Green'
ELSE 'Red'
ENDIF
8 - Asteroid

Pleasantly fiddly and a good reminder to look at the data rather than just reading the instructions.

8 - Asteroid

I thought that I was oversimplifying things, but maybe not.

Spoiler
13 - Pulsar
Spoiler

nice formula

8 - Asteroid
Spoiler
8 - Asteroid

Here's my solution

8 - Asteroid
Spoiler
6 - Meteoroid

solution attached

9 - Comet
Spoiler
9 - Comet
Spoiler

I could have reduced most of this to a single Formula tool, but maintenance would be more difficult.