N2xWVVLs

1class TrackService(models.Model):
2    ip = models.CharField(max_length=150, db_column='nm_grupo')
3    creation_date = models.DateField(auto_now_add=True,auto_created=True, db_column='dt_criacao') 
4     
5{ 'data': '14/08/2019', 'acesso_total': '10',
6  'cada_ip': {
7       '192.168.1.10': '7',
8       '192.168.1.11': '3'
9   },
10   'data': '13/08/2019', 'acesso_total': '15',
11  'cada_ip': {
12       '192.168.1.10': '5',
13       '192.168.1.11': '5',
14       '192.168.1.12': '5'
15   },
16   ...
17} 
18     
19teste = TrackService.objects.annotate(total=Count(
20    'creation_date')).values('ip', 'creation_date').annotate(total=Count('ip')) 
21     
22{'ip': '192.168.1.12', 'creation_date': datetime.date(2019, 8, 14), 'total': 2}
23{'ip': '192.168.1.13', 'creation_date': datetime.date(2019, 8, 14), 'total': 1}
24{'ip': '192.168.1.8', 'creation_date': datetime.date(2019, 8, 13), 'total': 1}
25{'ip': '192.168.1.9', 'creation_date': datetime.date(2019, 8, 13), 'total': 2}
26{'ip': '192.168.1.9', 'creation_date': datetime.date(2019, 8, 14), 'total': 1}