Nested aggregations in kibana


(Jon Stearley) #1

Hello. I'm trying to make a 2D contingency table in Kibana (eg domain by
_type). The below in Chrome/Sense returns reasonable results, but how do I
get this displayed in kibana? I'm trying to use a table panel but can't
figure out where to put the query - maybe a different panel or future
aggregations panel is needed? Thanks.

-Jon Stearley

HERE IS THE QUERY:

GET /_all/_search
{
"aggregations": {
"domains": {
"terms": {
"field": "DOMAIN"
},
"aggregations": {
"bytype": {
"terms":{
"field":"_type"
}
}
}
}
},
"size": 0
}

HERE IS AN EXAMPLE RESULT (actual domains and types anonymized):

{
"took": 252,
"timed_out": false,
"_shards": {
"total": 6,
"successful": 6,
"failed": 0
},
"hits": {
"total": 967233,
"max_score": 0,
"hits": []
},
"aggregations": {
"domains": {
"buckets": [
{
"key": "bleh.blech",
"doc_count": 3508,
"bytype": {
"buckets": [
{
"key": "type",
"doc_count": 3506
},
{
"key": "typeb",
"doc_count": 2
}
]
}
},
{
"key": "foo.gah",
"doc_count": 3470,
"bytype": {
"buckets": [
{
"key": "typea",
"doc_count": 3400
},
{
"key": "typeb",
"doc_count": 70
}
]
}
}
]
}
}
}

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/565187bd-5abe-433b-be07-44cd107bd607%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(Binh Ly-2) #2

Kibana is still using facets at the moment. Panels with ES aggregations
capabilities will be coming in the future. For now, you'll have to build
the panel yourself if you need it today.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/532e8bd3-1e2b-444c-92e5-d577a0b2c4da%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(system) #3