Django Aggregation: Summation of Multiplication of two fields

by

With Django 1.8 and above you can now pass an expression to your aggregate:

 from django.db.models import F

 Task.objects.aggregate(total=Sum(F('progress') * F('estimated_days')))['total']

Constants are also available, and everything is combinable:

 from django.db.models import Value

 Task.objects.aggregate(total=Sum('progress') / Value(10))['total']

More Related Contents:

  1. How do I filter query objects by date range in Django?
  2. Convert Django Model object to dict with all of the fields intact
  3. What’s the difference between select_related and prefetch_related in Django ORM?
  4. How do I do a not equal in Django queryset filtering?
  5. How to create an object for a Django model with a many to many field?
  6. Django orm get latest for each group
  7. LEFT JOIN Django ORM
  8. Django Blob Model Field
  9. Django values_list vs values
  10. “_set” in a queryset object in Django
  11. Count number of records by date in Django
  12. How to perform OR condition in django queryset?
  13. QuerySet, Object has no attribute id – Django
  14. Get the latest record with filter in Django
  15. Django filter JSONField list of dicts
  16. How to delete a record in Django models?
  17. Can a dictionary be passed to django models on create?
  18. django.core.exceptions.ImproperlyConfigured: Requested setting INSTALLED_APPS, but settings are not configured. plz help me out plz
  19. What is the difference between null=True and blank=True in Django?
  20. How to pull a random record using Django’s ORM?
  21. Django Unique Together (with foreign keys)
  22. Django : Table doesn’t exist
  23. django – convert a list back to a queryset [duplicate]
  24. How to filter objects for count annotation in Django?
  25. How do I separate my models out in django?
  26. Difference between AbstractUser and AbstractBaseUser in Django?
  27. Override a form in Django admin
  28. How can I set two primary key fields for my models in Django?
  29. What is the default order of a list returned from a Django filter call?
  30. Django get_profile() method not working on extended User model

Leave a Comment