Re: Grouping and Averages

2012-07-07 Thread Jeremy Branham
Thanks. At this time, it looks like it may be best to use a DB as a backing store, then scheduling a task to store pre-aggregated data and other documents in Solr. Jeremy Branham Software Engineer http://LinkedIn.com/in/JeremyBranham http://jeremybranham.wordpress.com/ http://Zeroth.biz

Re: Grouping and Averages

2012-07-07 Thread Jeremy Branham
field. Though I dont see how to sort the groups by document count. I thought maybe a pseudo field with a functional query would return a document element but my tests failed. Its a bit of a challenge to switch my thought process from SQL to Solr. Jeremy Branham Software Engineer http

Re: Grouping and Averages

2012-07-07 Thread Jeremy Branham
Thanks Jack! Jeremy Branham Software Engineer http://LinkedIn.com/in/JeremyBranham http://jeremybranham.wordpress.com/ http://Zeroth.biz -Original Message- From: Jack Krupansky Sent: Saturday, July 07, 2012 11:16 AM To: solr-user@lucene.apache.org Subject: Re: Grouping and Averages

Grouping and Averages

2012-07-07 Thread Jeremy Branham
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

Grouping and Stats

2012-07-06 Thread Jeremy Branham
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