We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #292: It's about Pivoting, Prepping and Reporting!

PhilipMannering
14 - Magnetar
14 - Magnetar

Solution in Python Tool,

Spoiler
PhilipMannering_0-1635788658536.png

 

AndrewSu
Alteryx
Alteryx

 I feel like.. there's an easier way to do it than I did. but this is my take 🙂 

Andrew Su
Sales Engineer
Alteryx
Spoiler
Capture.PNG
sara_burk
7 - Meteor
Use the following dataset to:* Pivot the data to show the count of the IDs for each group based on the region and respective team.* Arrange and prepare the d...
alexnajm
8 - Asteroid

Not my best work but it'll do!

TonyA
Alteryx
Alteryx

Here's my solution. A couple of extra steps to keep the headings clean.

Spoiler
TonyA_0-1635811793243.png

 

AkimasaKajitani
15 - Aurora

My solution.

 

Spoiler
AkimasaKajitani_0-1635812409035.png
AkimasaKajitani_1-1635812544505.png

 

 

kelvinlaw
8 - Asteroid

 

 

 

 

Here is my solution:

 

Spoiler
kelvinlaw_0-1635826786031.png
kelvinlaw_1-1635826827282.png

 

 

JasonHu
8 - Asteroid
Spoiler
workflow.png

Here is my submission.

dYoast
8 - Asteroid

My final columns are not as wide.

Spoiler
dYoast_0-1635858068435.png

 

dYoast_1-1635858090154.png