Weekly Challenge

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

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

Submit Feedback
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.

Challenge #218: Car Sales Reporting

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

Highlighted
14 - Magnetar
14 - Magnetar

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

 

Highlighted
Alteryx Certified Partner

Great practice with the Report Map tool!

Spoiler
218.png

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

Spoiler
Highlighted
Alteryx Partner

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
Highlighted
Alteryx Certified Partner

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

 

Highlighted
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

 

Highlighted
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
Highlighted
Alteryx Certified Partner

Here is my solution !

Highlighted
Alteryx Partner

 

Spoiler
dsmdavid_0-1591022532725.png

 

but..

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

 

 

Highlighted
11 - Bolide

 

Spoiler
kayers_0-1591022786403.png
kayers_1-1591022808578.png