On Sun, Oct 20, 2013, at 04:04 AM, Toby Lazar wrote: > Is it possible to get pivot info on a range-faceted query? For example, > if > I want to query the number of orders placed in January, February, etc., I > know I can use a simple range search. If I want to get the number of > orders by category, I can do that easily by faceting on category. I'm > wondering if I can get the number of all orders by month, and also broken > down by category. Is that possible in a single query?
You can't yet include a range facet within a pivot. The way to achieve this is to store a version of your date field rounded to the nearest month, then you will be able to use that field in a pivot facet. Obviously, this requires index time effort, which is less than ideal. I guess this is a feature just waiting for someone to implement it. Upayavira
