Median Date

2018-05-01 Thread Jim Freeby
All, We have a dateImported field in our schema. I'd like to generate a statistic showing the median dateImported (actually we want median age of the documents, based on the dateImported value). I have other stats that calculate the median value of numbers (like price). This was achieved with some

Re: Median Date

2018-05-02 Thread Jim Freeby
centiles='50' func}ms(NOW, importDate)&facet=true&facet.pivot={!stats=piv1 }status I hope this helps someone else :)  Also, let me know if there's a better way to do this. Cheers, Jim On ‎Tuesday‎, ‎May‎ ‎1‎, ‎2018‎ ‎03‎:‎27‎:‎10‎ ‎PM‎ ‎PDT, Jim Freeby wrote:

Facet Range with Stats

2018-05-11 Thread Jim Freeby
All, I'd like to generate stats for the results of a facet range. For example, calculate the mean sold price over a range of months. Does anyone know how to do this? This Jira issue seems to indicate its not yet possible. [SOLR-6352] Let Stats Hang off of Range Facets - ASF JIRA | | | | [SOLR-

Re: Facet Range with Stats

2018-05-11 Thread Jim Freeby
T00:00:00Z f.someDate.facet.range.end=2018-04-30T00:00:00Z f.someDate.facet.range.gap=+1MONTH facet.pivot={!stats=piv1 range=r1}category Please let me know if there's a better way to achieve this. Cheers, Jim On ‎Friday‎, ‎May‎ ‎11‎, ‎2018‎ ‎09‎:‎23‎:‎39‎ ‎AM‎ ‎PDT, Jim Freeby wrote: All, I'd li

Re: Facet Range with Stats

2018-05-11 Thread Jim Freeby
Correction.  The solution below did not quite get what we need. I need the stats reports for the range. I'll keep digging on this one On ‎Friday‎, ‎May‎ ‎11‎, ‎2018‎ ‎10‎:‎59‎:‎45‎ ‎AM‎ ‎PDT, Jim Freeby wrote: I found a solution. If I use tags for the facet range definition an