In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. 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 #434: Summing Across Many Rows

aiahwieder
9 - Comet

FloridaManChandlersWildlifeGIF.gif

RM_MOHANTY
7 - Meteor

CHALLENGE_SNAPSHOT.pngHey, Here's m

Spoiler
y Solution:
- Used Components:

- Python for Cleansing and modification 

- Multi Field Formula for addition. I have also included 2 more ways using CROSSTAB and TRANSPOSE

Joe-Smith-JLL
8 - Asteroid
Spoiler
JoeSmithJLL_0-1754679291562.png

 

codeRX
7 - Meteor

I like using the dynamic tools for this

 

Spoiler
Snag_f7704c.png

mirzaglamocak_alteryx
8 - Asteroid
Spoiler
mirzaglamocak_alteryx_0-1759106476655.png

 

estherb47
15 - Aurora
15 - Aurora
Spoiler
The Crosstab tool can calculate both the Total and the percent of row. Very efficient way to solve!

estherb47_1-1762310098906.png