Challenge #218: Car Sales Reporting

[AYXAcademy]

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.

[Kenda]

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

Spoiler

[Aaron_Harter]

Great practice with the Report Map tool!

Spoiler

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

Spoiler

[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

[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

[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.

[neilgallen]

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

Spoiler

[Jean-Balteryx]

Here is my solution !

[dsmdavid]

Spoiler

but..

Spoiler

@patrick_digan what is this witchery? 

[kelsey_kincaid]

Spoiler