select_data = {'date': "date_trunc('day', creationtime)"}
ttl = ReportWebclick.objects.using('cms').extra(select=select_data).filter(**
    filters).values('date', 'tone_name', 'singer', 'parthner', 'price',
    'period').annotate(loadcount=Sum('loadcount'), buycount=Sum('buycount'),
    cancelcount=Sum('cancelcount')).order_by('date', 'parthner')
Формат даты Django GROUP BY strftime