django orm group by date only code example

Example: django group by date from datetime field

Transaction.objects.values('created_at__date').annotate(count=Count('id')).values('created_at__date', 'count').order_by('created_at__date')