Challenge #152: Finding Vehicle Counts

[ipeng]

Spoiler

[CharlieS]

Spoiler

The Calgary Join can be configured to return the count of records that match certain criteria. So these are the only two tools needed.

[pjdit]

This time using the Calgary tools available..

Spoiler

[KevinW]

Ahhh.... much easier now that the index files are there.

Spoiler

I could have restricted the data to just count for the Blue Chevy's in the Calgary Cross Count Append, but put that in the filter instead so that any color or model of car could be checked on.

[ddiesel]

First time using Calgary tools. I like the features!

Spoiler

[ponraj]

Here is my solution. I have never heard about this place.  However, google image search helped me to find this place

Spoiler

[JosephSerpis]

Challenge Completed 

[rfergus]

Spoiler

Went the Calgary Input and join route too. Originally had a filter as well, but saw in the other solutions you could include query criteria in the calgary input.  First time using these tools.

[estherb47]

GREAT city! FUN tools. I've done very little with these so far, and clearly need to play some more :)

Took 2 approaches, one with a regular join, and one with a calgary cross count. Calgary join worked, but didn't get all of the fields I wanted in the output

Spoiler

[sachin02]

My solution without use of input data and summarize tool: