Challenge #309: Movie Catalogue

A solution to last week’s challenge can be found here. Weekly Challenge Image 309.png

The dataset is a short sample of Rotten Tomatoes's list of 100 best movies written by women. These are highly Certified Fresh films (nothing on the list falls below 94%) whose screenplay credit goes in part or fully to women.

The challenge is to create a PDF catalogue to create a list of 10 movies written by women. The catalogue must contain: name, cover, writer, synopsis, critics consensus, starring, director.

Extra cookies if you solve this challenge using the Tile tool!

Challenge 309_Start File.yxzp

Challenge 309_Solution File.yxmd

Reporting

Advanced

Data Preparation

Basic

Accepted answers

All comments

Do we have one that includes the output? Mine isn't showing that.

@mikemotter Thank you for letting us know it was missing, the file has been updated to include the output.

Spoiler

Here's my take:

Here's a sample of the pdf:

Challenge 309_Start File.yxmd

Spoiler

I would prefer the "Make Columns" option

challenge 309_solution_rsc.yxmd

Spoiler

Challenge 309_JM ABDC.yxmd

All,

Spoiler

This was a fun one!
-I used:
2 Crosstabs
4 Select Tools
1 Dynamic Rename
4 Text to Columns ( I used these versus using a Multi-Row formula to avoid any Custom Code, which is a thing of mine)
1 Download

Tool
1 Basic Table to finish up.
-Cheers!

Matt

Challenge 309_Reesetrain.yxzp

Here's my solution

Spoiler

Tried to keep it simple so I didn't use RegEx to remove the labels from the cells.

Challenge 309_TonyA.yxmd

I want those extra cookies! 😊">🍪

Spoiler

challenge_309_start_file_Alex Abi-Najm.PNG

Challenge 309_Start File_Alex Abi-Najm.yxmd

Mmm Cookies

Spoiler

Challenge 309_DS.yxmd

Spoiler

Challenge 309_Start File.yxmd

Spoiler

Challenge 309_Start File_EK.yxmd

Spoiler

Challenge 309_Start File.yxmd

Spoiler

Did it the long way

Challenge 309_JJ.yxmd

Spoiler

challenge 294_solution_kceleven11.yxmd

AkimasaKajitani

My solution!

Spoiler

Challenge 309_Start File_AK.yxzp

Fun challenge, here is my solution:

Spoiler

Challenge 309_Solution.yxmd

Thanks @AYXAcademy for this challenge. Nice revision on Tile Tool and Reporting Tools.

Spoiler

Challenge 309_Solution_AllwynThomas.yxzp

Output does not 100 % match the solution's report. My report only contains one record instead of two. I am curious for the solution.

Attached the pdf to the soultion. Nice to know how this works 😀

Challenge 309_Start File_aantoni.yxmd

Top 10 Movies Written by Women.pdf

Spoiler

Solution Attached

Challenge 309_Start File.yxmd

philipmannering

Spoiler

Challenge 309 - Movie Catalogue.yxmd

This was a fun and insightful challenge.

Note: Flixster is blocked by my company's firewall, so I had to copy images from the Output PDF and save to my PC.

Spoiler

Challenge 309 Solution JF.yxmd

Spoiler

Spoiler

Spoiler

Weekly Challenge 309_Solution_CI.yxmd

Fun One:

Emil_Kos_309.yxzp

My solution :

Spoiler

Challenge 309_Solution_Toons.yxzp

Spoiler

309 - 1.png

309 - 2.png

challenge_309_LiuZhang.yxzp

Good reporting practice!

Spoiler

challenge_309_solution_klg.yxmd

Hi,

Please find attached solution to the Challenge #309.

Thanks

D Nelson

Challenge 309_Solution_Nelson.yxzp

My solution_

Challenge 309_MK.yxmd

Good challenge!

Spoiler

challenge_309_solution_file_jb.yxzp

We really need more women to step up to the writer's podium!

Spoiler

challenge_309_tbrown.yxmd

Spoiler

Challenge 309_Start _JG.yxmd