Community

count content type grid view and change link

I am setting up a grid view that displays an image and I would like to also show the number of nodes related to the grid content. But if I turn on aggregation I get a sql error due to the image. Any ideas?

Here is a link to what I have so far.

http://serviidb.com/pluginGrid

I also want when the image is clicked on, it takes you to the following.

http://serviidb.com/plugin-api-name/hdtrailers

currently it takes you to.

http://serviidb.com/content/hd-trailers

thanks in advance for any help you can give me.