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

Milanz
8 - Asteroid

done;-)

KilianL
Alteryx Alumni (Retired)

"Let me factor in the previous row..."

 

Spoiler
074 - Build a Factorial Calculator - Kilian.png

 

TraceyD
Alteryx Alumni (Retired)

Here's my solution:

Sashikumar
8 - Asteroid

Nth Factorial.

Spoiler
ch74.PNG
byagelski
8 - Asteroid

I took a different approach to the challenge and made an analytic app that you enter the number and it calculates the factorial.

TheOC
15 - Aurora
15 - Aurora

This would be an interesting one to come back and try to improve! It's definitely far from perfect as is... Although as I've learnt with Alteryx, if it works, then the 'most optimal' solution is likely just a millisecond faster to run!

 

 

Spoiler
TheOC_0-1613785855754.png

Batch macro with the following configuration:

TheOC_1-1613785878354.png



Interestingly, i ran into problems with the first row - so had to have a filter to apply the rowcount to 2 for that. However, everything else went swimmingly!

 


Bulien
rcarog
8 - Asteroid

Solution attached.

garrettlem1017
8 - Asteroid

Solution has been attached.

Luke_C
17 - Castor
Spoiler
Challenge074.PNG

Jon-B
7 - Meteor

Somehow I always assume an iterative program is required and spent ages looking into an iterative macro solution. For some reason I thought the challenge required it, but when I realised a standard macro would do, I went with the generate rows function like many others. An important lesson here in not over-engineering. "Keep it simple stupid".