Do it on the client, strip off the date and add together ny values you have for the same hour.
Upayavira On Sat, Feb 9, 2013, at 06:15 AM, Cool Techi wrote: > Hi, > > I want to facet results on an hourly basis, the following query gives me > an hourly breakdown, but with the date part. I want just the hour part > across the days. Is there any other way of doing this, > > <lst name="params"> > <str name="facet.date.start">2013-02-01T00:00:00Z-330MINUTES</str> > <str name="facet">true</str> > <str name="q">twitterId:191343557</str> > <str name="facet.date">createdOnGMTDate</str> > <str name="facet.date.gap">+1HOUR</str> > <str name="facet.date.end">2013-02-08T23:59:59Z-330MINUTES</str> > <str name="rows">0</str> > </lst> > > Result---- > > <int name="2013-01-31T18:30:00Z">0</int> > <int name="2013-01-31T19:30:00Z">0</int> > <int name="2013-01-31T20:30:00Z">0</int> > <int name="2013-01-31T21:30:00Z">0</int> > <int name="2013-01-31T22:30:00Z">0</int> > <int name="2013-01-31T23:30:00Z">0</int> > > Desired Result > > <int name="18:30:00Z">0</int> > <int name="19:30:00Z">0</int> > <int name="20:30:00Z">0</int> > <int name="21:30:00Z">0</int> > <int name="22:30:00Z">0</int> > <int name="23:30:00Z">0</int> > > Regards, > Ayush >
