# Visualize output query ES

**URL:** https://discuss.elastic.co/t/visualize-output-query-es/66530
**Category:** Kibana
**Created:** [November 18, 2016, 11:35am UTC](https://discuss.elastic.co/t/visualize-output-query-es/66530 "2016-11-18T11:35:30Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![emanuele](https://avatars.discourse-cdn.com/v4/letter/e/e0b2c6/32.png) [@emanuele](https://discuss.elastic.co/u/emanuele)
#### Post date: [November 18, 2016, 11:35am UTC](https://discuss.elastic.co/t/visualize-output-query-es/66530/1 "2016-11-18T11:35:30Z")

</div>

Hello,

how can i visualize the output query below?

> {  
> "query" : {  
> "match": {  
> "flag\_bar": 1  
> }  
> },  
> "aggs": {  
> "for\_mun":{  
> "terms":{  
> "field":"mun"  
> , "order": {  
> "\_term": "asc"  
> }  
> },  
> "aggs" : {  
> "numero\_seg" : { "sum" : { "field" : "flag\_bar" } },  
> "numero\_abi" : { "sum" : { "field" : "flag\_ana" } },  
> "numero\_int" : { "sum" : { "field" : "flag\_int" } },  
> "division": {  
> "bucket\_script": {  
> "buckets\_path": {  
> "my\_var1": "numero\_seg",  
> "my\_var2": "numero\_int"  
> },  
> "script": "params.my\_var1 / params.my\_var2"  
> }  
> }  
> }  
> }  
> }  
> }

I want to as how create data table with two column: "for\_mun" and "division".  
It's possible?

Thanks

---

<div class="post-metadata">

### Author: ![tylersmalley](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tylersmalley/32/8833_2.png) [@tylersmalley](https://discuss.elastic.co/u/tylersmalley)
#### Post date: [November 20, 2016, 8:30pm UTC](https://discuss.elastic.co/t/visualize-output-query-es/66530/2 "2016-11-20T20:30:39Z")

</div>

What version of Kibana/Elasticsearch are you using?

Just so I understand the question; this a query you created, and you're now looking to re-create within Kibana?

---

<div class="post-metadata">

### Author: ![emanuele](https://avatars.discourse-cdn.com/v4/letter/e/e0b2c6/32.png) [@emanuele](https://discuss.elastic.co/u/emanuele)
#### Post date: [November 21, 2016, 11:35am UTC](https://discuss.elastic.co/t/visualize-output-query-es/66530/3 "2016-11-21T11:35:09Z")

</div>

Hi,  
I use version 5 of Kibana/Elasticsearch.  
yes, i want visualize the output with kibana's native "visualize" of other "visualize" custom.

Thanks

---

<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: [December 19, 2016, 11:35am UTC](https://discuss.elastic.co/t/visualize-output-query-es/66530/4 "2016-12-19T11:35:26Z")

</div>

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