Django Average, Minimum, Maximum, Sum from Queryset


Example

class Product(models.Model):
    name = models.CharField(max_length=20)
    price = models.FloatField()

To Get average price of all products:

>>> from django.db.models import Avg, Max, Min, Sum
>>> Product.objects.all().aggregate(Avg('price'))
# {'price__avg': 124.0}

To Get Minimum price of all products:

>>> Product.objects.all().aggregate(Min('price'))
# {'price__min': 9}

To Get Maximum price of all products:

>>> Product.objects.all().aggregate(Max('price'))
# {'price__max':599 }

To Get SUM of prices of all products:

>>> Product.objects.all().aggregate(Sum('price'))
# {'price__sum':92456 }