ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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.

SUBMIT YOUR IDEA

Challenge #74: Build a Factorial Calculator

vbrown
8 - Asteroid

My solution.

KFarmer
6 - Meteoroid

Here's my solution:

 

KFarmer_0-1622758029075.png

KFarmer_1-1622758063193.png

 

 

euanwilson
8 - Asteroid

6th challenge complete. 

 

Spoiler
So initially I used the generate rows tool to create a new column named 'Factorial' where each number, n, had n iterations in the Factorial column. So for example the number 3 takes up 3 rows in the Number column and in the corresponding rows in the Factorial column we have 3,2,1 as per the factorial formula. Then with the use of the multi-row formula tool I calculated each iterative step of the factorials. After being stuck for a while about how to only take the max value of each number, i.e the actual factorial, I had a look at some of the solutions and saw the summarize tool can be used to take the max value of the factorial column and group by the number column. After this it was just a case of using the select tool to rename the columns to match up with the output in the solution. 

Workflow.PNGResults.PNG
JasonHu
8 - Asteroid
Spoiler
Spoiler
workflow.png

Here is my submission.

Maskell_Rascal
13 - Pulsar

Here is my solution!

 

Spoiler
Workflow/Results:
Maskell_Rascal_0-1623168938616.png


Macro:

Maskell_Rascal_1-1623168959298.png

 

Cheers!

Phil

Jonny
11 - Bolide

had fun doing this one, got inspiration from some of the solutions and built an analytical app.

Spoiler
Here is my app setup:
Jonny_0-1623251825872.png

interface screen:
Jonny_1-1623251935592.png


Results window:

Jonny_2-1623251956035.png

 

 

cheers!

 

 

Erin
11 - Bolide
Spoiler
Great practice with that multirow formula tool that I am determined to master one day! 
TonyAdam
8 - Asteroid

That was not too hard 🙂

 

Spoiler
tonyadam_0-1623685743277.png

 

paultno
8 - Asteroid

Here is mine!  I wonder if anyone else created a bunch of fields!

cwkoops
8 - Asteroid

!