CiviCRM Community Forums (archive)

Hey

the groups should be available to list, as of 3.0, the count on the other hand is not so easy.  You may want to kick the tires on the "views group by" module, http://drupal.org/project/views_groupby, though I have had mixed results with it.  The groups that are available are only available through a contact record, so you won't be able to list groups that have no members

The next major release of Views (Views 3) should be able to get you closer and it will support group by statements in views, and consequently count, sum, and a couple other aggregate functions.  That said Views 3 is still in alpha.

You might also want to look at the views_calc module: http://drupal.org/project/views_calc

You can SUM, AVERAGE, COUNT, MIN, MAX, or AVG selected columns. A plug in theme makes the view look more spreadsheet-like (right justifies numeric fields, shades calculated columns and rows, and underlines calculated rows).

You can also create custom dynamic fields that can be used in any view using SQL snippets like CONCAT('field_first_name', ' ', 'field_last_name') or DATE_FORMAT(node.created, '%m/%%d/%Y'). The custom fields are set up in admin/settings/views_calc.