Make the Right Queryset

[Ha]

hello django users !

I don't know how to do the right queryset, to get total mail have status='affecté' in the same date I used a queryset like this :

Evenement.objects.annotate(Day=TruncDay('date_Evt')).values('Day')\

   .annotate(affecte=Count('mail_item_fid',filter=Q(status='affecté')))\

   .all().order_by('Day')

but I want to get something like : 

Total mail have status 'affecté' : (for example 100)

date when the mail have status 'affecté': (for example 09/07/2020)

Day+0 : (here total mail have status 'livré' in day difference = 0)   [ I mean by day difference is the (day when mail have status 'livré' ) - (day when mail have status'affecté ' ) ]

Day + 1: (here total mail have status 'livré' in day difference = 1)

and so on 

 

I don't know if this possible to have something like this here 
 

 

here is my class : 

class Evenement(models.Model):

   EVENEMENT_CHOICES = (

       ("déposé","déposé"),

       ("reçu","reçu"),

       ("expédié","expédié"),

       ("affecté","affecté"),

       ("livré","livré"),

       ("echec de livraison","echec de livraison"),

   )

   mail_item_fid = models.ForeignKey(mail_item,on_delete=models.CASCADE, related_name='mail_item_fid_evenement')

   from_office = models.ForeignKey(Office,on_delete=models.CASCADE, related_name='office_Evt_evenement')

   date_Evt = models.DateTimeField()

    status = models.CharField(max_length=50,choices=EVENEMENT_CHOICES)

   agent_delivery_cd = models.ForeignKey(Delivery_Agent,on_delete=models.CASCADE,blank=True, null=True ,related_name='agent_evenement')

   def __str__(self):

       return '{}, {}, {}, {} '.format(self.mail_item_fid,self.from_office,self.date_Evt,self.status)

can you help me out if it is possible