Challenge #497: Badge Battle

[AYXAcademy]

Hi Community members,

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

This challenge was submitted by Douglas Perez, @dougperez . Thank you, Douglas, for your submission!

A company recently hosted an internal Alteryx certification event to promote professional growth and upskilling across the organization. Each participant was assigned to a team, and throughout the event, employees earned various professional certifications.

Now that the event has concluded, it’s time to analyze the results and determine which team came out on top!

You’ve been provided with two datasets:

• A certifications dataset containing certification records, each with its status (Expires or Expired) and the date.
• A team mapping dataset linking each participant to their respective team.

Analyze the results and rank the teams based on the number of valid certifications earned by their members. Follow the rules below:

• Only include certifications that are currently valid (status is Expires).
• Focus only on certifications with names that include Alteryx Designer or Server.
• Exclude any certifications that mention Cloud or Trifacta.
• Aggregate the results by team and rank them from highest to lowest based on the number of valid certifications.

Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.

Good Luck!

The Academy Team

 

Source: Dataset generated by ChatGPT.

Download Start File

Download Solution File 

[Hub119]

Happy Friday!

Spoiler

[AkimasaKajitani]

My solution!

Spoiler

[Qiu]

Congratulations to Team#1.

Spoiler

Make Columns Tool is very helpful in this situation.

[nSpire]

Spoiler

 

[RolandSchubert]

Spoiler

[Yoshiro_Fujimori]

My solution.

Spoiler

Workflow


Formula Tool
  [Type] = IF Mod([RecordID], 2) = 1 THEN "Certification Type" ELSE "Certification Date" ENDIF
  [RecordID] = CEIL([RecordID] / 2)

Filter Tool 1
  StartsWith([Certification_Date], "Expires")

Filter Tool 2
  Contains([Certification_Type], "Alteryx Designer") OR Contains([Certification_Type], "Server")

Filter Tool 3
  !Contains([Certification_Type], "Cloud") AND !Contains([Certification_Type], "Trifacta")

Multi-Row Formula Tool
  [Rank] = IF [Row-1:Count] != [Count] THEN [Row-1:Rank] + 1 ELSE [Row-1:Rank] ENDIF

[RebekaMazuchova]

:)

[revac]

This was a true Monday Motivation!

Spoiler

[DaisukeTsuchiya]

Spoiler