Re: date difference faceting

2016-01-08 Thread David Santamauro
For anyone wanting to know an answer, I used facet.query={!frange l=0 u=3110400}ms(d_b,d_a) facet.query={!frange l=3110401 u=6220800}ms(d_b,d_a) facet.query={!frange l=6220801 u=15552000}ms(d_b,d_a) etc ... Not the prettiest nor most efficient but accomplishes what I need

Re: date difference faceting

2016-01-08 Thread Erick Erickson
I'm going to side-step your primary question and say that it's nearly always best to do your calculations up-front during indexing to make queries more efficient and thus serve more requests on the same hardware. This assumes that the stat you're interested in is predictable of course... Best, Eri

date difference faceting

2016-01-08 Thread David Santamauro
Hi, I have two date fields, d_a and d_b, both of type solr.TrieDateField, that represent different events associated with a particular document. The interval between these dates is relevant for corner-case statistics. The interval is calculated as the difference: sub(d_b,d_a) and I've been a