Hello - I’m not sure If this is an appropriate use for Solr, but I want to stay away from a typical DB store for high availability reasons.
I am storing documents that may have a common value for a field we’ll call “category”. In another field there will be an integer field we’ll call “rating”. I would like to group the documents on the “category” field and display the average “rating” per group. The stats component lets me get the avg rating, but when I collapse the results into groups it gives me the average for the entire collection, rather than for the specific group. Am I going about this wrong? Is it possible to get the desired outcome with a single query? I’d appreciate any insight! Thank you, Jeremy Branham Software Engineer http://LinkedIn.com/in/JeremyBranham http://jeremybranham.wordpress.com/ http://Zeroth.biz
