Getting stats on Date facet groups

[Andrew Shumway]

Using solr version 4.5 and an index of commercial flights data and am getting 
record counts by faceted date.  I also want to get the total of an integer 
field by faceted date but am having difficulty.

Here are the fields:
departureDateGMT
carrier
seatingCapacity

If I set facet=true, facet.date= departureDateGMT, 
facet.date.start=2013-12-01T00:00:00Z, facet.date.end= 2015-02T00:00:00Z, 
facet.date.gap=+1MONTH then things work great and I get record-count breakouts 
as follows

"facet_dates":{
      " departureDateGMT ":{
        "2013-12-01T14:00:00Z":513,
        "2014-01-01T14:00:00Z":4520,
        "2014-02-01T14:00:00Z":4599,
        "2014-03-01T14:00:00Z":5503,
        "2014-04-01T14:00:00Z":4679,
        "2014-05-01T14:00:00Z":5013,
        "2014-06-01T14:00:00Z":4501,
        "2014-07-01T14:00:00Z":3017,
        "2014-08-01T14:00:00Z":4411,
        "2014-09-01T14:00:00Z":5546,
        "2014-10-01T14:00:00Z":5646,
        "2014-11-01T14:00:00Z":4993,
        "2014-12-01T14:00:00Z":5434,
        "2015-01-01T14:00:00Z":965,
        "gap":"+1MONTH",
        "start":"2013-12-01T14:00:00Z",
        "end":"2015-02-01T14:00:00Z"}
}

Now I also want to do the same thing but instead record counts for each date 
group I want the total of seatingCapacity which is an integer field.  Does 
anyone know how to do this?


--Andrew Shumway

smime.p7s
Description: S/MIME cryptographic signature