where('is_placeholder', '=', false)->count(); $placeholderUserCount = User::query()->where('is_placeholder', '=', true)->count(); $activeInLastWeek = User::query() ->where('is_placeholder', '=', false) ->whereHas('timeEntries', function (Builder $query): void { /** @var Builder $query */ $query->where('created_at', '>=', now()->subWeek()) ->orWhere('updated_at', '>=', now()->subWeek()); }) ->count(); return [ Stat::make('Total', $usersCount) ->color('primary') ->description('Total real users'), Stat::make('Placeholder', $placeholderUserCount) ->color('danger') ->description('Placeholder users'), Stat::make('Active', $activeInLastWeek) ->color('success') ->description('Active users in the last seven days'), ]; } }