Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHad fun solving this challenge!! Specially configuring bar chart and table.
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.
I got a slightly different numeric result with James Patterson as I parsed on "with" as well as "and" and ", ". Same best seller list.
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!
Great challenge to practice with the report tools!