Search: Terms Stats Facet

[kimchy]

The terms_stats facet combines the terms and stats facet to group based on a key_field unique terms and compute stats (count, total, min, max) on another value field or script. For example:

{
    "query" : {
        "match_all" : {  }
    },
    "facets" : {
        "tag_price_stats" : {
            "terms_stats" : {
                "key_field" : "tag",
                "value_field" : "price"
            }
        }
    }
}

The size parameter controls how many facet entries will be returned. It defaults to 10. Setting it to 0 will return all terms matching the hits.

Ordering is done by setting order, with possible values of term, reverse_term, count, reverse_count, total, reverse_total, min, reverse_min, max, reverse_max. Defaults to term.

The value computed can also be a script, using the value_script provided, in which case the lang can control its language, and params allow to provide custom parameters (as in other scripted components).

Note: It is expected that the will be a single value of the key field per doc, and one or multiple values of the value field.

[kimchy]

Search: Terms Stats Facet, closed by 352cb74.

[deinspanjer]

wow. pivot tables for the win!

[itthuyloi]

In page: http://www.elasticsearch.org/guide/reference/api/search/facets/terms-stats-facet.html

"Note, the terms stats can work with multi valued key fields, or multi valued value fields, but not when both are multi valued (as ordering is not maintained)."

But how to build the query, I want to statistic of "hoursWorked" of a "Task log" have for {groupId and projectId}, please tell me!

I tried:

{
    "query": {
        "match_all": {
            
        }
    },
    "facets": {
        "hoursWorked_stats": {
            "terms_stats": {
                "key_field": ["groupId",
                "projectId"],
                "value_field": "hoursWorked",
                "size": 1000
            }
        }
    }
}

But it's not working!

[rbnacharya]

#6046

Count issue in terms stat facet. Please visit the issue..