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 #230: Take a Look, It's in a Book!

pirroav
6 - Meteoroid

First pass at a solution, where the best seller year is based on the date of publication. 

 

edit: uploaded the wrong version, oops!

Tony_Castillo
9 - Comet
Spoiler
TC_bot_0-1598286021848.png TC_bot_1-1598286032569.png

 

2014 result is tied at 9 - 'The Best of Me' by Nicholas Sparks  (Matches answer in output) & 'The Target' by David Baldacci (New Answer). Based on sorting rule, David Baldacci's 'The Target' wins as he had the higher # of weeks result. 

huynv96
9 - Comet

try to comment

RobertW
Alteryx
Alteryx

Not too bad.  Needed the brush-up on reporting tools.

 

Spoiler
RobertW_0-1598289690805.png



RobertW_1-1598289753917.png

 

TonyA
Alteryx Alumni (Retired)

Here's my solution. Always fun tweaking a report to get it just right

Spoiler
2020-08-24_10-22-28.png

 

patrick_digan
17 - Castor
17 - Castor
Spoiler
patrick_digan_0-1598291436205.png

 

cblazer
6 - Meteoroid

Definitely have some additions to the reading list after this one! 

Spoiler
230 Image.png
paulfound
11 - Bolide
Spoiler
PaulFound_0-1598305257909.png
PaulFound_1-1598305306450.png

 

LHolmes
9 - Comet

***Updated solution yxzp to account for additional dual authors that the embedded output leaves out.***

 

Probably some opportunity to streamline the parsing. The plus side is more documentation 🙂 

Fun challenge, loved playing with the charting tools and reporting tools.

 

Spoiler
230 - Solution.PNG
230 - Report.PNG

 

Qiu
20 - Arcturus
20 - Arcturus

Caught for the the author name part.

Spoiler
en-230.PNG