Re: Multiple annotations in one query

2018-09-24 Thread David
Thanks Matthew will take a look. On Monday, 24 September 2018 15:40:44 UTC+1, Matthew Pava wrote: > > Hi David, > > Performing multiple annotations on a queryset is not the same as combining > multiple aggregations. > > Saying that, if you truly are getting wrong results, you could try using > t

RE: Multiple annotations in one query

2018-09-24 Thread Matthew Pava
Hi David, Performing multiple annotations on a queryset is not the same as combining multiple aggregations. Saying that, if you truly are getting wrong results, you could try using the Window functions or the Subquery object. https://docs.djangoproject.com/en/2.1/ref/models/database-functions/#wi