# Elasticsearch query on kibana

**URL:** https://discuss.elastic.co/t/elasticsearch-query-on-kibana/43411
**Category:** Kibana
**Created:** [March 3, 2016, 4:10pm UTC](https://discuss.elastic.co/t/elasticsearch-query-on-kibana/43411 "2016-03-03T16:10:03Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![luis.carvalho](https://avatars.discourse-cdn.com/v4/letter/l/d07c76/32.png) [@luis.carvalho](https://discuss.elastic.co/u/luis.carvalho)
#### Post date: [March 3, 2016, 4:10pm UTC](https://discuss.elastic.co/t/elasticsearch-query-on-kibana/43411/1 "2016-03-03T16:10:03Z")

</div>

Hi,

I would like to know if it's possible in some way, to visualize the next Elasticsearch query on a kibana metric or chart? I tried using JSON input but without a good result, and I don't know if it's the correct way.

```
GET _search
{
   "query": {
    "match_all": {}
  },
  "aggs": {
     "per_day": {
      "date_histogram": {
        "field": "@timestamp",
        "interval": "day"
      },
      "aggs": {
        "MISS_Sum": {
         "sum": { "field": "MISS" }
        },
        "HTTP_Sum": {
          "sum" : {"field": "HTTP_Request"}
        },
        "Manifest_Sum": {
         "sum": { "field": "Manifest_Request"}
       },
       "m3u8_Sum": {
         "sum": {"field": "m3u8_Request"}
       },
        "Cache_MISS": {
         "bucket_script": {
            "buckets_path": {
              "miss_sum": "MISS_Sum",
              "http_sum": "HTTP_Sum",
              "manifest_sum": "Manifest_Sum",
              "m3u8_sum": "m3u8_Sum"
            },
            "script": "miss_sum / (http_sum - manifest_sum - m3u8_sum)"
         }
        }
      }
    }
  }
}

```

The goal is to show the Cache\_MISS value.

Thanks.

---

<div class="post-metadata">

### Author: ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)
#### Post date: [March 9, 2016, 5:26am UTC](https://discuss.elastic.co/t/elasticsearch-query-on-kibana/43411/2 "2016-03-09T05:26:25Z")

</div>

Kibana search bar does not accept query DSL aggregations - you'd have to build the aggregations using the vis builder in Visualize. Unfortunately, the bucket\_script aggregation is not yet supported in Kibana Visualize (it's experimental in ES so we may not see it quite yet).

For what you're trying to accomplish, you may be able to do it using the [Timelion Kibana plugin](https://www.elastic.co/blog/timelion-timeline). It takes a different approach from pipeline aggs, but does do some more advanced time-series math. Have you tried it yet? If you do, we'd love your feedback [here](https://github.com/elastic/timelion).

---

<div class="post-metadata">

### Author: ![luis.carvalho](https://avatars.discourse-cdn.com/v4/letter/l/d07c76/32.png) [@luis.carvalho](https://discuss.elastic.co/u/luis.carvalho)
#### Post date: [March 9, 2016, 11:08am UTC](https://discuss.elastic.co/t/elasticsearch-query-on-kibana/43411/3 "2016-03-09T11:08:20Z")

</div>

Thank you Tanya for your help. I'll try the Timelion plugin to do my time-series math. If it works, I'll be glad to post a feedback here.

Thanks again,

Luís Carvalho

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 1:59pm UTC](https://discuss.elastic.co/t/elasticsearch-query-on-kibana/43411/4 "2017-07-06T13:59:45Z")

</div>