Brief
Add a column to the Order Grid, entitled "Total Orders" that shows the total count of orders for each customer.
Problem
I've taken what I've understood from here. This has successfully managed to create the desired column but without any results. I believe the error lies somewhere within part 2 of my implementation.
Where I'm at
1 - Override created /app/code/local/Mage/Adminhtml/Block/Sales/Order/Grid.php
2 - Added below to _prepareCollection()
$alias = 'subselect';
$subselect = Mage::getModel('Varien_Db_Select',
Mage::getSingleton('core/resource')->getConnection('core_read')
)->from('sales_flat_order_grid', array(
'customer_id as s_customer_id',
'count(*) as total_orders')
)->group('customer_id');
$collection->getSelect()
->joinInner(array($alias => $subselect),
"{$alias}.s_customer_id = main_table.customer_id");
3 - Added below to _prepareColumns()
$this->addColumn('total_orders', array(
'header' => Mage::helper('sales')->__('Total Orders'),
'index' => 'total_orders',
'filter_index' => 'total_orders',
));