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

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