Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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!

dsmdavid
11 - Bolide

Spent the most time getting the reporting just right -- why header and footer are not showing in png, html, pptx but are in pdf?

 

Spoiler
dsmdavid_0-1598559854458.png

 

dsmdavid_1-1598559749560.png

 

 

CKent
6 - Meteoroid

Enjoyed playing w/ the Reporting Tools!

 

naresh5315
7 - Meteor

My solution: Workflow

Spoiler
naresh5315_0-1598591684907.png

 

My solution: Chart

Spoiler
naresh5315_1-1598591712516.png

 

coracai
8 - Asteroid

Another one down. 

hamza_khan
7 - Meteor

Considering that I am not a book worm, I made my workflow look like one.

PriyankaaJ
7 - Meteor

As my colleague pointed it out, records with multiple authors are separated by an "and" and a "with". So there is a slight difference in the total number of weeks and the total count of books.

 

Spoiler
PriyankaaJ_0-1598659899692.png

 

RichoBsJ
11 - Bolide

Hi! Nice challenge! Here my solution 🙂

 

By the way, the provided solution is inaccurate; for example, James Patterson should sum 200 weeks instead of 195, because the provided solution hasn't taken into account the 5 weeks of the books that have a "with" word in the "author" field...

 

Spoiler
Graph:

graph.png

Table:

table.png
balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1598803105495.png

 

dlopez13
7 - Meteor

Doesn't look like the recommended output accounted for this, but I applied fuzzy matching to the split author names to account for inconsistent formatting.  It did result in a small increase to the data that made it into the chart.  

Spoiler
dlopez13_2-1598826139365.png



 

mbogusz
9 - Comet
Spoiler
2020-08-31 08_26_36-Greenshot.pngEngine_18192_561dc376cb01491ebd3b6033a234610d_.png