DMZ 1.7.1 (DataMapper OverZealous Edition)

[eluser]Tom Vogt[/eluser]
I'm trying to use count(*) and group_by together and can't figure out how to do that using DMZ.

In SQL, what I want to do is roughly this:

Code:

SELECT count(*), some_field, AVG(other_field) FROM table WHERE group_id = 1 GROUP BY some_field;

now I came as far as

Code:

$this->table->group_by('some_field')->select('some_field')->select_avg('other_field')->get();

which gives me everything but the count. Then I thought doing

Code:

foreach ($this->table as $x) {
   $count = $x->count();
}

would work, but it gives me the total numbe of results, not the individual count for each row. Someone got a better idea for the DMZ equivalent of the SQL I posted above?