Wanted to create a view which made use of group by and count function. But the view default had no such capabilty so and additional module was introduced in an ever growing list of module.

the views group by module

http://drupal.org/project/views_groupby

It worked fine :)

will try to give something back one day.