We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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
17 - Castor
Spoiler
binuacs_0-1664804056358.png

 

MilindG
11 - Bolide
Spoiler
MilindG_0-1664804149542.png

 

AkimasaKajitani
16 - Nebula
16 - Nebula

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