Challenge #218: Car Sales Reporting

A solution to last week's challenge can be found here. Source: https://thenewswheel.com/top-5-worst-car-salesmen-from-movies/

In this week's challenge explore the reporting tools to help Arnold create a visualization for his car sales last month.

Arnold at Platinum Motors would like to get a better picture of his car sales from the last month. Using the provided dataset, create a report that shows the locations of the buyers, color-coded by the type of car purchased, with a legend. Underneath the report, put a table that shows the number of sales and average sale price by car type.

challenge_218_start_file.yxmd

Car Sales Report.pdf

challenge_218_solution.yxmd

Reporting

Advanced

Intermediate

Accepted answers

All comments

Kenda

I love all that you can do with maps in Alteryx (now that I actually know how to use this tool).

Spoiler

challenge_218_start_file.yxmd

Aaron_Harter

Great practice with the Report Map tool!

Spoiler

(edit 6/1 10:06 CDT) video of solution overview:

Spoiler

challenge_218_AB Data_Aaron.yxmd

johnemery

This was a good challenge. Not particularly difficult, but with a few elements that I think all Alteryx developers should have in their toolkit.

Spoiler

View my solution video here:

Spoiler

Challenge 218 Solution johnemery.yxmd

Blake

Why do chicken coops only have 2 doors?

Spoiler

If they had 4, they'd be chicken sedans!

The report map tool took me a bit to get the hang of...

Spoiler

challenge_218_start_file_BH.yxmd

patrick_digan

Spoiler

i know it's not hard to transpose and crosstab, but I just use my own macro "Transpose (Excel Style)" to accomplish it one step without any real configuration.

challenge_218_start_file.yxzp

neilgallen

As someone who actually does report vehicle sales for a living, this one hits a little close to home.

tumblr_nlr9mleWgp1rwtzqno1_540

Spoiler

challenge_218_NGA.yxmd

Jean-Balteryx

Here is my solution !

challenge_218_workflow.yxmd

dsmdavid

Spoiler

but..

Spoiler

@patrick_digan what is this witchery?

david_218.yxzp

output.pdf

kelsey_kincaid

Spoiler

challenge_218_ka.yxmd

JamesFo

Enjoyed some new tools here!

Spoiler

Challenge 218 - JF.yxmd

OllieClarke

I don't think my table method is optimal, looking forward to seeing how people better at reporting tools than I did it

Spoiler

challenge_218_OC_solution.yxmd

AngelosPachis

Challenge #218 solved

Spoiler

challenge_218_solved_AP.yxmd

philipmannering

As always, about 45 minutes fiddling around with the reporting tools configurations to get what I wanted...

Spoiler

Report

Workflow

Challenge 218 - Car Sales Reporting.yxmd

FlorianC

Good practice for the reporting tools.

Spoiler

Challenge #218.yxzp

EllenChen

Good practice for report map!

challenge_218_Solution_EC_1.yxmd

balajilolla

Spoiler

Solution Attached

challenge_218_start_file.yxmd

cgoodman

Here's my solution and video walkthrough

challenge_218_solution.yxmd

RolandSchubert

Reporting tools ... really not my daily business.

Workflow:

Spoiler

Output:

Spoiler

challenge_218_solution_rsc.yxmd

abrouwer

Spoiler

challenge_218_solution_file - AJB.yxmd

ggruccio

I had more trouble configuring the table than the map!

challenge_218_gg_finish.yxmd

deviseetharaman

Spoiler

Solution Updated

challenge_218_sol_devi_updated.yxmd

T_Willins

My solution. Fun to play with the reporting tools as I do not get to use them that much in my day-to-day.

Spoiler

Result

Workflow

challenge_218_solution.yxmd

cmv

I was familiar with the map tool, but table was a challenge.

Spoiler

challenge_218_solution_cmv.yxmd

izamryan

Solved! Hello Arnold, this was a great opportunity to practice using the Reporting and the Map tools.

Spoiler

This pattern of a Sum -> Transpose -> Cross-tab is a very useful one.

challenge_218_solution_(izamryan).yxmd

ab3106694

Here's my attempt - its not perfect, there's a few flaws in it! Now have to go research how to fix them...

challenge_218_AB attempt.yxmd

NapasornCh

Also spiced up the formatting with legend building and overlay

Challenge_218_Car Sales Report_NapasornCH.pdf

challenge_218_NapasornCH.yxmd

Mengdee

good one!

challenge_218_solution.yxmd

Ladarthure

My solution!

challenge_218_start_file.yxmd

LorenzoDB_dup_193

Hi, this is my solution. This Challenge has been a great chance for me to improve my report's skiils (tha was very low before this exercise).

Spoiler

Challenge #218 - Car Sales Reporting - LDB - Scai Finance.PNG

Challeng_218_LDB_ScaiFinance.yxmd

Verakso

Here is my solution, oddly enough, my biggest struggle was formatting the table

Spoiler

Also, with out the Visual Layout tool, I couldn't figure out how to combine my elements in the report

The Workflow

I think I came pretty close, but it nags me a bit, that the legend on the map is so much bigger

The ResultI will have to take peeks at the other solutions.

Still Climbing
/Verakso

challenge_218_solution_verakso.yxmd

Vinicius28498

Congratulations guy!

jennifer_owens

Took way to long trying to determine how to prevent my legend from line breaking only to find the solution suffers from the same problem... that is, the map image in the output does not match the solution perfectly. Now to see if anyone else figured it out.

Well, I just figured out I just needed to resize my own preview window... lesson learned

challenge_218_JO Answer.yxzp

Archie_bos

Here is my solution

challenge_218_complete_file.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335