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 #249: Highlights

DataHabanero
9 - Comet

Ready!

Samanthaj_hughes
ACE Emeritus
ACE Emeritus

It was a good one 🙂

#Alteryxrocks
Shifty
12 - Quasar

REALLY enjoyed this challenge.  I've been intimidated by the Reporting tools but being forced to have a go proved that it was actually pretty intuitive. I feel like I've opened a door to a previously unexplored part of Alteryx. 🤗

 

Spoiler
Shifty_0-1620640395841.png

 

LukaszKarpinski
8 - Asteroid

Hi,

 

My solution attached.

 

Spoiler
LukaszKarpinski_0-1620640833197.png

 

Kind Regards,

Łukasz

Steph_Maddrell
8 - Asteroid

Pretty much identical to the others! Not too many ways you could do this one though. Good to practice the reporting tools.

 

Spoiler
Steph_Maddrell_0-1621188460286.png
Rebecca_Neville
7 - Meteor

Probably not the fastest way to get there but it works 💃

sonyakasenkramer
8 - Asteroid
Spoiler
sonyakasenkramer_0-1622224080819.png

 

SIVARANJANI
6 - Meteoroid

Tableau.Siv simple solution

cplewis90
13 - Pulsar
13 - Pulsar

My solution.

euanwilson
8 - Asteroid
Spoiler
So to find the highest value in the data set I used the transpose tool to place all the values in one column before using a summarize tool to calculate the max value. 

After using append fields to place a max value column onto the original data set with record ID's placed on them it was just a case of using the basic table tool and making use of the column rules to highlight the max value and achieve the required result.

Workflow.PNGResults.PNG