I think I have this about working with the analytics component. It seems to fill in all the gaps that the stats component and the json facet don't support.
It solved the following problems for me: - I am able to perform math on stats to form other stats.. Then i can sort on those as needed. - When I perform math on stats it uses the summed totals per group rather than doing it per row - I am able to to do offsets and number of rows to handle paging I am confused why this module isn't built into Sor. This functionality is so vital for any adhoc querying on time series data. Pretty much any scenario like the SQL query I provided would need all of these things. Only thing I couldn't figure out is how to get the list of total buckets... or in other words the distinct count of keywords. If anyone is able to help with this, I could really use it in order to provide a total record count to the user (e.g. Showing records 1-10 of 2939). Here is what I have in case this helps someone: olap=true&o.r1.ff=keyword_s&o.r1.s.visits=sum(visits_i)&o.r1.s.bounces=sum(bounces_i)&o.r1.s.bounce_rate=div(sum(bounces_i),sum(visits_i))&o.r1.ff.keyword_s.sortstatistic=bounce_rate&o.r1.ff.keyword_s.sortdirection=desc&o.r1.ff.keyword_s.offset=0&o.r1.ff.keyword_s.limit=10 Also if anyone has access to the original documentation from bloomberg mentioned in the stats component PDF, I'd love to have it :) https://issues.apache.org/jira/secure/attachment/12606793/Search%20Analytics%20Component.pdf All the links for detailed documentation are now broken. -- View this message in context: http://lucene.472066.n3.nabble.com/Division-with-Stats-Component-when-Grouping-in-Solr-tp4211402p4211751.html Sent from the Solr - User mailing list archive at Nabble.com.
