Vega filter with controls in dashboard

Elastic Stack Kibana
1

Hello everyone,
Hope one of you can help me, i would like to know if it is possible to use control filters on a vega visualization that involves aggregations, and queries. In my example, i'm trying to filter by a particular day field the whole graph generated by vega.

Do you have any insight about how to do this??

Here, i have some pictures and the code of vega.

image
image604×650 125 KB

{
"$schema": "https://vega.github.io/schema/vega-lite/v2.json",
"title": "Daily Count",
"data": {
"url": {
"index": "hs_index",
"body": {
"size": 0,
"track_total_hits": true,
"query": {
"match": {
"order_sent": "ORDER/INSERT"
}
},
"aggregations": {
"order_over_time": {
"date_histogram": {
"field": "@timestamp",
"format": "yyyy-MM-dd hh:mm-ss",
"interval": "15m"
}
}
}
}
},
"format": {"property": "aggregations.order_over_time.buckets"}
},
"mark": "bar",
"encoding": {
"x": {"field": "key", "type": "temporal", "axis": {"title": false}},
"y": {
"field": "doc_count",
"type": "quantitative",
"axis": {"title": "# of orders"}
},

color: {"value": "#ff9900"},

legend: { title: 'Memory_serie' }

}
{
"$schema": "https://vega.github.io/schema/vega-lite/v2.json",
"title": "Daily Count",
"data": {
"url": {
"index": "hs_index",
"body": {
"size": 0,
"track_total_hits": true,
"query": {
"match": {
"order_sent": "ORDER/INSERT"
}
},
"aggregations": {
"order_over_time": {
"date_histogram": {
"field": "@timestamp",
"format": "yyyy-MM-dd hh:mm-ss",
"interval": "15m"
}
}
}
}
},
"format": {"property": "aggregations.order_over_time.buckets"}
},
"mark": "bar",
"encoding": {
"x": {"field": "key", "type": "temporal", "axis": {"title": false}},
"y": {
"field": "doc_count",
"type": "quantitative",
"axis": {"title": "# of orders"}
},

color: {"value": "#ff9900"},

legend: { title: 'Memory_serie' }

}
}

Thanks so much,

JUAN DAVID BRICENO GUERERO

2

Sadly no, Vega queries elasticsearch independently, not through Kibana mquery so the filters on a dashboard won't have any effect on Vega.

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.