Count unique values and group by date

I have a table like:

So, I need to count amount of unique clients with group by date. The result should look like {'date': 2024-10-10, "count_visits": 2}.

I tried several variations with annotate(unique=True) and OuterRef, but it never worked to group by date.

For pure ORM solution you should be able to use this

from django.db.models import Count
from django.db.models.functions import TruncDate

YourTable.objects.annotate(pure_date=TruncDate('your_date_field_name')).values('pure_date').annotate(count_visits=Count('client_id', distinct=True))