Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #339: Say Cheese (Part 1)

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found here.

 

Are you ready to explore a cheesy dataset?image_339_1200x600.png

 

This dataset provides information about the 2021 World Cheese Awards.

 

Your challenge is to:
- Find the category of cheese that has the highest average rating per category. Your answer must include the category number, the average rating, and the category name.
- Find all the companies that have a perfect rating of 4 in the category they entered. Your answer must include the company name, the average rating , and the count.


Hints:
You need to create a new rating system column based on the following:
SUPER GOLD = 4
GOLD = 3
SLIVER = 2
BRONZE = 1

 

In addition, create 2 new columns, category number and category name, using information from the category column.

Mahmood
7 - Meteor

 

 

Spoiler
I guess I cheated a little bit using the join tool to find the companies with all 4 rating!Screenshot 2022-10-03 082300.jpg

 

Sebastian_Chaieb2
8 - Asteroid
8 - Asteroid

My solution

Spoiler
Sebastian_Chaieb2_0-1664804095956.png

 

binuacs
20 - Arcturus
Spoiler
binuacs_0-1664804056358.png

 

MilindG
12 - Quasar
Spoiler
MilindG_0-1664804149542.png

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
AkimasaKajitani_0-1664804906446.png

 

RyanG45
7 - Meteor
Spoiler
This was a puzzler - but a good challenge.  

RyanG45_0-1664805546545.png

 

balajilolla1
8 - Asteroid
Spoiler
Solution Attached

balajilolla1_0-1664805993867.png

 

ggruccio
ACE Emeritus
ACE Emeritus

Love using Expect Equal to check my work!

 

Spoiler
 ggruccio_1-1664807686245.png

 

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
339.png