[Solved] SOLR Group BY and SUM - CodeProject

Please Visit: http://ift.tt/1ajReyV



SOLR Group BY and SUM

http://ift.tt/1eJIL9L

SELECT sum(TransCount), sum(NetSales)

FROM Core

WHERE BusinessDateTime BETWEEN '2012/04/01' AND '2013/04/01'

GROUP BY MONTH(BusinessDateTime)



using SOLR stats combined with facets to get the NetSales and TransCount for each day.

&q=:

&fq=BusinessDateTime:[2012-03-01T00:00:0Z TO 2013-03-01T23:59:5Z]

&rows=0

&stats=on

&stats.field=NetSales

&stats.field=TransCount

&stats.facet=BusinessDateTime



from Google Plus RSS Feed for 101157854606139706613 http://ift.tt/1eJIL9L

via LifeLong Community