Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Cloud Quests

Elevate your workflow skills by solving real-world challenges using the Alteryx Analytics Cloud Platform.

Cloud Quest #6: Girl Power in Math

Dlawless610
7 - Meteor

 Here is my solution 

CC#5.jpg

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !

Shelbey
Alteryx
Alteryx
Spoiler
Screenshot 2024-05-29 154303.png
SGolnik
11 - Bolide
11 - Bolide

Always enjoy these!

 

Spoiler
Quest 6 Screenshopt.png
OllieClarke
15 - Aurora
15 - Aurora

Here's my solution:

Spoiler
Quest_06.png
Towers
11 - Bolide

fun one!

Spoiler
Screenshot 2024-05-31 134140.png

mceleavey
17 - Castor
17 - Castor

I am flying with these.

 

Spoiler
I first applied a filter to isolate those records for Females with Grade 8 and the years which contained 2013 or 2019.
I then used a Summarise tool to create groupings of District, Year and Level 4 Percentage.
From there I simply sorted into the correct order and cross-tabbed to create a row per district, with the Percentage of Level 4 split into columns. It was then a matter of calculating the difference between the two.
For task two, it was a simple sort and sample to highlight the top three.
Workflow.png

Task 1 Results.pngTask 2 Results.png


Bulien

phottovy
13 - Pulsar
13 - Pulsar

Another quest completed!

 

Things I liked

  • Sorting built directly into the "Sample tool

Things I didn't like:

  • The lack of the "Cross-Tab" tools ability to dynamically pick up changes to columns. For example, if I decided I wanted to compare two different years, I would have to click "Reset" in the cross-tab tool to pick up the additional columns

 

Spoiler
006.png
mshishido
8 - Asteroid

ms

ggruccio
ACE Emeritus
ACE Emeritus

It pays to read directions - or at least investigate the data before joining 😀

Spoiler
Screenshot 2024-07-03 141035.png