I am trying write query to get below stats for orders data Find Total Order Count, sum(Quantity) and sum(Cost) for specified date range in a gap of 1 day. example if date range is for 10 days then get these result for every day for 10 days.
Solr Version : 5.2.1 Example Order Solr Doc <doc> <long name="ORDER_ID”>123456</long> <date name=“ORDER_DATE">2014-09-30T18:56:17Z</date> <int name="QUANTITY">2</int> <float name="COST">233.00</float> </doc> Query example using range facet to get count but not sure how to get sum(quantity) and sum(cost) in same query. is there other way to get these data from single or multiple query. single query would be better solr/orders/select?q=*%3A*&wt=xml&indent=true&facet=true&facet.range=ORDER_DATE&f.ORDER_DATE.facet.range.start=NOW/DAY-1DAYS&f.ORDER_DATE.facet.range.end=NOW/DAY%2B10DAYS&f.ORDER_DATE.facet.range.gap=%2B1DAY Response: <lst name="facet_counts"> <lst name="facet_queries"/> <lst name="facet_fields"/> <lst name="facet_dates"/> <lst name="facet_ranges"> <lst name=“ORDER_DATE"> <lst name="counts"> <int name="2016-03-09T00:00:00Z">1289</int> <int name="2016-03-10T00:00:00Z">295</int> <int name="2016-03-11T00:00:00Z">0</int> <int name="2016-03-12T00:00:00Z">0</int> <int name="2016-03-13T00:00:00Z">0</int> <int name="2016-03-14T00:00:00Z">0</int> <int name="2016-03-15T00:00:00Z">0</int> <int name="2016-03-16T00:00:00Z">0</int> <int name="2016-03-17T00:00:00Z">0</int> <int name="2016-03-18T00:00:00Z">0</int> <int name="2016-03-19T00:00:00Z">0</int> </lst> <str name="gap">+1DAY</str> <date name="start">2016-03-09T00:00:00Z</date> <date name="end">2016-03-20T00:00:00Z</date> </lst> </lst> </lst> </response>
