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
7 - Meteor

Get to learn something about reporting

Spoiler
218.PNG
Highlighted
11 - Bolide

I'm getting back in the Weekly Challenge game, after a couple of busy months. This was great practice with reporting tools!

 

Output:

Spoiler
kelly_gilbert_0-1591668691265.png

 

Workflow:

Spoiler
kelly_gilbert_1-1591668817919.png

 

Highlighted
8 - Asteroid

I started solving the weekly challenges couple of days ago and was able to accomplish the very first 11 challenge, but I decided to do a couple from the newer ones, this one pushed me to learn about maps and reporting in general.

 

I love reporting in everything, it make me feel the result of my work so I really enjoyed making a report with Alteryx too.

 

Solution:

 

Spoiler
AliAS2020_0-1591679272026.png



Next I will learn the header/footer and other reporting tools.

Happy learning!

 

AliAS

Highlighted
Alteryx
Alteryx

Here is my solution

Spoiler
ArtApa_0-1591691123685.png

 

Highlighted
8 - Asteroid

Great challenge!  I had never used the Report Map tool before, so this was a great way to learn how to use it and that it exists.

Spoiler
Challenge 218 JWL.JPG
Highlighted
Alteryx Certified Partner

I feel the day that I understand reporting in Alteryx well enough is getting closer...

Spoiler
Spoiler
fiddled around with the report map to tweak its thematic field and ensuring it's using a smart tile unique setting... besides this I aligned some text to theleft in the table settings.fiddled around with the report map to tweak its thematic field and ensuring it's using a smart tile unique setting... besides this I aligned some text to theleft in the table settings.
Highlighted
8 - Asteroid

Here is my solution... probably an easier way to build the table...

Highlighted
8 - Asteroid

This was cool, I've spent more time than necessary and I could have played even longer with the options.

One thing I couldn't do and is something I might come back to, is to colour the whole row text based on value in a single column, so if vehicle type = SUV I want everything to be coloured in green. Something to explore one day

 

Spoiler
hanykowska_0-1591801334356.png

And my messy workflow...

hanykowska_1-1591801355846.png

 

Highlighted
9 - Comet

My solution

 

Spoiler
challenge_218_mysolution.jpg
Highlighted
6 - Meteoroid

Here is my solution...