Re: Count values grouped by date

2012-02-20 Thread Martin Tiršel
On Mon, 20 Feb 2012 18:33:40 +0100, Tom Evans wrote: On Mon, Feb 20, 2012 at 5:17 PM, Martin Tiršel wrote: (btw, are you sure that works for views? looks like it is counting clicks as well) Yes, that was counting all records. This type

Re: Count values grouped by date

2012-02-20 Thread Tom Evans
On Mon, Feb 20, 2012 at 5:17 PM, Martin Tiršel wrote: > Hi, > > I have: > > class BannerStats(models.Model): >    ACTION_TYPE_VIEW = 0 >    ACTION_TYPE_CLICK = 1 > >    ACTION_TYPES = ( >        (ACTION_TYPE_VIEW, 'view'), >        (ACTION_TYPE_CLICK, 'click'), >    ) > >    

Count values grouped by date

2012-02-20 Thread Martin Tiršel
Hi, I have: class BannerStats(models.Model): ACTION_TYPE_VIEW = 0 ACTION_TYPE_CLICK = 1 ACTION_TYPES = ( (ACTION_TYPE_VIEW, 'view'), (ACTION_TYPE_CLICK, 'click'), ) banner = models.ForeignKey( Banner ) date = models.DateTimeField(