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

Spoiler
AWC_152.PNG
Bolide

Nice one, never had the opportunity to use calgary tools before!

Atom
Spoiler
Capture.JPG
Meteoroid

Never used Calgary before, but I believe I was able to link the tables (under Options --> run analytics apps) then I could use Calgary cross count straight away. I included the query information in the cross count configuration section (vs. a filter). Then it was just a matter of filtering out zeroes.152_a.PNG

152_c.PNG152_b.PNG

Asteroid

I really like calagry databases, i use them to store pretty much all my data now as they are so quick!

Spoiler
152.PNG
Meteor

Done!

 

Spoiler
Capture.PNG
Alteryx Partner

Nice one! :)

Bolide
Bolide

Had a little help from this tool!

Spoiler
Capture.JPG
Asteroid

My first pass ignored the hint, so I redid it with some research.

 

Spoiler
Spoiler 152.PNG
Asteroid

It is my first time using Calgary. I'd like to learn more about Calgary tools.