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 #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