1054 Unknown column 'total' in 'order clause'' ? about tracker HOT 3 CLOSED

$query =
        $this
            ->select(
                'tracker_events.id',
                'tracker_events.name',
                $this->getConnection()->raw('count(tracker_events_log.id) as total')
            )
            ->from('tracker_events')
            ->period($minutes, 'tracker_events_log')
            ->join('tracker_events_log', 'tracker_events_log.event_id', '=', 'tracker_events.id')
            ->groupBy('tracker_events.id', 'tracker_events.name')
            ->orderBy('total', 'desc');

$this->getConnection()->raw('count(tracker_events_log.id) as total')