Index: trunk/core/units/visits/visits_event_handler.php =================================================================== diff -u -N -r2737 -r2741 --- trunk/core/units/visits/visits_event_handler.php (.../visits_event_handler.php) (revision 2737) +++ trunk/core/units/visits/visits_event_handler.php (.../visits_event_handler.php) (revision 2741) @@ -72,7 +72,7 @@ { $object->addCalculatedField('OrderTotalAmountSum', 'SUM(IF(ord.Status = 4, ord.SubTotal+ord.ShippingCost+ord.VAT, 0))'); $object->addCalculatedField('OrderAffiliateCommissionSum', 'SUM( IF(ord.Status = 4,ord.AffiliateCommission,0))'); - $object->addCalculatedField('OrderCountByVisit', 'COUNT(OrderId)'); + $object->addCalculatedField('OrderCountByVisit', 'SUM( IF(ord.Status = 4, 1, 0) )'); } if (!$types){