Weekly Challenge

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

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

Submit Feedback
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.

Challenge #176: Math Class Drill

Highlighted
Alteryx
Alteryx

A solution to last weeks' challenge can be found here

 

The end of summer is near, and it's nearly time to head back to school! Get your brain back into the swing of things with this math class drill. @KaneG  found this problem in his desk on a piece of paper, and he thought it'd be heaps easier to solve in Alteryx. Is he right?

 

https://www.xkcd.com/1856/https://www.xkcd.com/1856/

 

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

My solution.

Spoiler
12-08-_2019_17-50-25.png
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

My solution. Could have pivoted also...

 

Spoiler
Capture.PNG
Highlighted
11 - Bolide

Fun!

Spoiler
176.png
Highlighted
14 - Magnetar
14 - Magnetar

I love the smell of math in the morning.

 

Spoiler
My solution - 371! I like that it's only 1 off from one of the other known answers, 370. Gotta love the power of one.
WeeklyChallenge176.JPG

Cheers!

NJ

Highlighted
9 - Comet
Fun! Solution Attached
Highlighted
8 - Asteroid

Great Challenge!

Spoiler
Solution-Challenge 176.PNG
Highlighted
8 - Asteroid
Spoiler
challenge176_viveknshah.JPG
Highlighted
17 - Castor
17 - Castor

And there I was ready to say "001".  Doh!

 

Spoiler
Like @PhilipMannering and @RolandSchubert, I went for single formula solution

WF.png


A very repetitive single formula

Pow(tonumber(Substring(tostring([RowCount]),0,1)),3) +
Pow(tonumber(Substring(tostring([RowCount]),1,1)),3) +
Pow(tonumber(Substring(tostring([RowCount]),2,1)),3)

Dan

Highlighted
14 - Magnetar
14 - Magnetar
Spoiler
My first thought was to generate numbers 0-9 then append them a couple times to get my list of possible numbers. This left 0 as a possible first number, but none of these turned out as answers so I left it as is.


Capture.PNG