CODEWITHSUNDEEP
djangodjango-querysetdjango-aggregation
Mridang Agarwalla
Mridang Agarwalla

Reputation: 44978

Average calculated on the difference on a Min and Max value in Django

I have two simple tables in Django which looks like:

class Session(models.Model):
    id = models.AutoField(primary_key=True)

class Track(models.Model):
    id = models.AutoField(primary_key=True)
    session = models.ForeignKey(Session)
    when = models.DateTimeField(null=False, auto_now_add=True)

I need to find a the average duration of all the sessions. The duration of a session is calculated by subtracting the highest when value with the lowest when value. Can I do something like this:

Session.objects.all().annotate(duration=Max('track__when') - Min('track__when')).aggregate(Avg('duration'))

Any better methods?

Thanks.

Upvotes: 2

Views: 662

Answers (1)

rewritten
rewritten

Reputation: 16435

As I already answered you the same question in Querying data from Django , you can't do using only the ORM API, either:

  1. you extend the API by defining your custom annotations, or
  2. you do part of the algorithm in python, in your view/templatetag/whatever

Upvotes: 1

Related Questions