RainbowPesimist

date_total = by_day.values('date_transaction', "score_id").\
        annotate(total_sales=Sum('total', filter=Q(type=Transaction.Type.SALE)),
                 total_expenses=Sum('total', filter=Q(type=Transaction.Type.EXPENSE)))