Re: Help with aggregates needed

2019-03-01 Thread Felix Carbonell
Hello, Simon. Thank you very much! Your solution worked like a charm!!! Best regards, Felix. El jueves, 28 de febrero de 2019, 0:09:35 (UTC-5), Simon Charette escribió: > > Hello Felix, > > month = ... > year = ... > Expenses.objects.filter( > year=year, > ).values( > area_name=F('area__n

Re: Help with aggregates needed

2019-02-27 Thread Simon Charette
Hello Felix, month = ... year = ... Expenses.objects.filter( year=year, ).values( area_name=F('area__name'), element_name=F('element__name') ).annotate( year_sum=Sum('cost'), month_sum=Sum('cost', filter=Q(month=month)), ) Should generate SQL along the following lines on Postg

Help with aggregates needed

2019-02-27 Thread Felix Lazaro Carbonell
Hi to everyone: Having models like these: class Area(models.Model): name = models.CharField(max_lentgh=30) class Element(models.Model): name = models.CharField(max_lentgh=30) class Expenses(models.Model): area = models.ForeignKey(Area, on_delete=models.CASCADE )