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 #292: It's about Pivoting, Prepping and Reporting!

PhilipMannering
16 - Nebula
16 - Nebula

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 🙂 

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 data so that the number of players in each group is listed under each region and team * Create a report that illustrates the data you ...
alexnajm
16 - Nebula
16 - Nebula

Not my best work but it'll do!

TonyA
Alteryx Alumni (Retired)

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

Spoiler
TonyA_0-1635811793243.png

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
AkimasaKajitani_0-1635812409035.png
AkimasaKajitani_1-1635812544505.png

 

 

kelvin_law1
9 - Comet

 

 

 

 

Here is my solution:

 

Spoiler
kelvinlaw_0-1635826786031.png
kelvinlaw_1-1635826827282.png

 

 

JasonHu
8 - Asteroid
Spoiler
workflow.png

Here is my submission.

dYoast
11 - Bolide

My final columns are not as wide.

Spoiler
dYoast_0-1635858068435.png

 

dYoast_1-1635858090154.png