We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #218: Car Sales Reporting

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found hereSource: https://thenewswheel.com/top-5-worst-car-salesmen-from-movies/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
15 - Aurora
15 - Aurora

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

 

Spoiler
Kenda_0-1591016566291.png

 

Aaron_Harter
11 - Bolide

Great practice with the Report Map tool!

Spoiler
218.png

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

Spoiler
johnemery
10 - Fireball

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
Map Capture.PNGWorkflow Capture.PNG

 View my solution video here:

Spoiler
Blake
12 - Quasar

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
Blake_0-1591017893301.png

 

patrick_digan
16 - Nebula
16 - Nebula
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.patrick_digan_0-1591018180506.png

 

neilgallen
12 - Quasar

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

tumblr_nlr9mleWgp1rwtzqno1_540

 

Spoiler
Annotation 2020-06-01 093341.png
Jean-Balteryx
14 - Magnetar

Here is my solution !

dsmdavid
11 - Bolide

 

Spoiler
dsmdavid_0-1591022532725.png

 

but..

Spoiler
@patrick_digan what is this witchery? dsmdavid_2-1591022737893.png

 

 

kelsey_kincaid
11 - Bolide

 

Spoiler
kayers_0-1591022786403.png
kayers_1-1591022808578.png