community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #152: Finding Vehicle Counts

Asteroid

The hint made it too easy.

Spoiler
Spoiler.PNG
Asteroid
 
Alteryx
Alteryx
 
Meteor
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