Filter relationship withCount

[SDIjeremy]

I have a table of Users that shows how many "active" Posts they have. I'd like to filter the posts_count based on a filter of how many days back to look. (1 day, 7 days, 30 days)

So for the Filter, if you'd filter timeframe=7 I want it to only count Posts for the past 7 days that have comments on them.
Right now the code I have seems to actually hide the Users who do not have Posts with activity, instead of showing their count as 0.

QueryBuilder::for(User::active())
            ->defaultSort('posts_count')
            ->allowedSorts(['name', 'posts_count'])
            ->allowedFilters([
                AllowedFilter::scope('timeframe', 'posts.activityTimeframe'),
            ])
            ->allowedIncludes(['posts'])
            ->withCount(['posts' => fn (Builder $posts) => $posts->published()])
            ->paginate(5, pageName: 'users')
            ->withQueryString()

public function scopeActivityTimeframe(Builder $signals, int $days): Builder
{
        return $signals->whereRelation('comments', fn (Builder $comments) =>
            $comments->whereNotNull('comments.approved_at')->whereDate('comments.approved_at', '>=', now()->subDays($days))
        );
}

[SDIjeremy]

This works but it's very dirty

->withCount(['posts => fn(Builder $posts) => $posts->published()->activityTimeframe($request->users_filter['timeframe'] ?? null)])