Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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