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

ARussell34
8 - Asteroid

Census data has been summed!

 

AR_434.png

olga_strubbe
11 - Bolide

Thank you, @Hollingsworth, this was a neat challenge! 

I could have used 'Cross Tab' and 'Transpose' tools, but I've decided to use CReW 'Add Totals' macro instead which I love to make it a bit simpler :)  

2024-07-22_21-29-11.png

Qiu
21 - Polaris
21 - Polaris

The data of solution need some cleansing to fully comply with the question.

Spoiler
Challenge_434.png
kapilrautela_1990
6 - Meteoroid
My Solution

 

 

Luke_C
17 - Castor
17 - Castor
Spoiler
image.png
agoston_reka
6 - Meteoroid

Challenge #434: Summing Across Many Rows

aatalai
15 - Aurora

C434

griffinwelsh
12 - Quasar

My solution

danbostrom
8 - Asteroid

 

 

mmontgomery
11 - Bolide
11 - Bolide

C434

Spoiler
c434.png