Pivot with Stats (or Stats with Pivot)

[eduardo]

Hi All,

  Is it possible to get stats (like Stats Component: min ,max, sum, count, 
missing, sumOfSquares, mean and stddev) from numeric fields inside 
hierarchical facets (with more than one level, like Pivot)?

  I would like to query: 
...?q=*:*&version=2.2&start=0&rows=0&stats=true&stats.field=numeric_field1&stats.field=numeric_field2&stats.pivot=field_x,field_y,field_z
  and get min, max, sum, count, etc. from numeric_field1 and 
numeric_field2 from all combinations of field_x, field_y and field_z 
(hierarchical values).


  Using stats.facet I get just one field at one level and using 
facet.pivot I get just counts, but no stats.

  Looping in client application to do all combinations of facets values 
will be to slow because there is a lot of combinations.


  Thanks a lot!