Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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