community
cancel
Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #152: Finding Vehicle Counts

Asteroid

The hint made it too easy.

Spoiler
Spoiler.PNG
Asteroid
 
Alteryx
Alteryx
 
Asteroid
Spoiler
challenge152_viveknshah.JPG

For A Summarise addict, this was a good exercise to pause and think 

Alteryx Certified Partner

19

 

Spoiler
Capture.PNG
 
Alteryx
Alteryx

Here's my solution.

Spoiler
I used a crosstab tool to aggregate. I cheated a bit by taking advantage of the fact that the AW100 field was always 1. If it wasn't I would have added a field that was all 1's.
Alteryx Partner

Interesting challenge - first time using a Calgary DB

 

Spoiler
w152.PNG
Meteoroid
Spoiler
Challemge_152.PNG
Meteor

My solution is attached

 

Spoiler
152.PNG
Calgary Cross Count to Count and Filter for Blue Chevy
Calgary Input to bring in region code to name mapping
Use join as filter for desired dataset.

Probably could have all been done in the Calgary Cross Count Append tool if the db were indexed.