Display a Table Count of Users by DOB

modx-user-dob-table

//SNIPPET

$datearr = [];

$users = $modx->getIterator('modUser', array('active'=>'1'));

foreach ($users as $user) {
  $profile = $user->getOne('Profile');
  $dob = date("Y", $profile->get('dob'));
  
    if(array_key_exists($dob,$datearr)){
        $datearr[$dob]++;
    } else {
        $datearr[$dob] = 1;
    }
  
}

ksort($datearr);

foreach($datearr as $key => $value){
    $output .= $modx->parseChunk('dob-row-loop',array('year' => $key,'count' => $value));
}

$table = $modx->parseChunk('dob-row-table', array('rows' => $output));
return $table;


//chunk dob-row-loop
<tr><td>[[+year]]</td><td>[[+count]]</td></tr>

//chunk dob-row-table
<table class="border" cellpadding="0" cellspacing="0">
<thead>
    <tr>
        <th>D.O.B.</th>
        <th>Count</th>
    </tr>
</thead>
<tbody>
    [[+rows]]
</tbody>
</table>