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
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
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,
