Hi, Here is a query with a sample result set.
http://localhost:8983/solr/myindex/select?q=*%3A*&wt=json&indent=true&stats=true&stats.field={!tag=piv1}size&facet=true&facet.limit=10&facet.pivot={!stats=piv1}object&rows=0 "facet_counts":{ "facet_queries":{}, "facet_fields":{}, "facet_dates":{}, "facet_ranges":{}, "facet_intervals":{}, "facet_pivot":{ "object":[{ "field":"object", "value":"2_supervision", "count":76657, "stats":{ "stats_fields":{ "size":{ "min":18.0, "max":61.0, "count":76657, "missing":0, "sum":4590645.0, "sumOfSquares":2.75310789E8, "mean":59.88552904496654, "stddev":2.277412264831095, "facets":{}}}}}, { "field":"object", "value":"2_spw-super-010", "count":8694, "stats":{ "stats_fields":{ "size":{ "min":0.0, "max":61.0, "count":8694, "missing":0, "sum":510886.0, "sumOfSquares":3.042645E7, "mean":58.763054980446285, "stddev":6.827549006021397, "facets":{}}}}}, { "field":"object", "value":"4_10.1.1.100", "count":7441, "stats":{ "stats_fields":{ "size":{ "min":0.0, "max":61.0, "count":7441, "missing":0, "sum":421964.0, "sumOfSquares":2.475678E7, "mean":56.70796935895713, "stddev":10.549794992510861, "facets":{}}}}} Is it possible to sort the facet pivot items by using a stat value like sum or mean ? Thank you. Dominique
