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!

JoseV
7 - Meteor
Spoiler
JoseV_0-1599330500204.png

 

Malvim
11 - Bolide

First time with Reporting Tools. Nice one!

 

Spoiler
Malvim_0-1599330811157.png

 

Seema123
7 - Meteor
Spoiler
solution.JPG

Had fun solving this challenge!! Specially configuring bar chart and table. 

TramT
6 - Meteoroid

Like some others, I also ended up with 200 days instead of 195 for James Patterson by accommodating for  'with' in the author field.

Also did some fuzzy matching on the author names to catch some variations, though turned out to be inconsequential to the end result.

Spoiler
TramT_0-1599440417745.png
TramT_2-1599440479131.png

 

 

 

estherb47
15 - Aurora
15 - Aurora

Always love a literary challenge

 

EstherB47_0-1599618344629.png

 

T_Willins
14 - Magnetar
14 - Magnetar

I got a slightly different numeric  result with James Patterson as I parsed on "with" as well as "and" and ", ".  Same best seller list.

 

Results 230.png

 

Spoiler
Workflow 230.png

 

kelly_gilbert
13 - Pulsar

A good little challenge, with parsing, prep, and reporting! I learned something new on this one - I didn't know how to relocate the legend (from the margin to floating over the chart), so I had to look that up!

 

Spoiler
I learned that to move the legend, you just have to click and drag it while previewing in the Interactive Chart tool!


Workflow:
challenge_230_workflow.PNG


Output:

challenge_230_output.PNG
kmickelson
8 - Asteroid

Uploading my solution

JP_SDAK
8 - Asteroid

I'm sure there was an easier way to parse the authors - but I did eventually get it to work.

Spoiler
JP_SDAK_0-1599877153012.pngJP_SDAK_1-1599877209333.pngJP_SDAK_2-1599877242867.png

 

 

jwlong91
8 - Asteroid

Great challenge to practice with the report tools!

Spoiler
Challenge 230 JWL.JPG