# Bucketed query in Kibana

**URL:** https://discuss.elastic.co/t/bucketed-query-in-kibana/54106
**Category:** Kibana
**Created:** [June 28, 2016, 5:13am UTC](https://discuss.elastic.co/t/bucketed-query-in-kibana/54106 "2016-06-28T05:13:18Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![pvignesh92](https://avatars.discourse-cdn.com/v4/letter/p/bcef8e/32.png) [@pvignesh92](https://discuss.elastic.co/u/pvignesh92)
#### Post date: [June 28, 2016, 5:13am UTC](https://discuss.elastic.co/t/bucketed-query-in-kibana/54106/1 "2016-06-28T05:13:19Z")

</div>

Hello All,

We built a query from topbeat data by applying buckets and scripts. I wanted a build a logic by comparing the avg cpu, avg memory and avg fs utilization and visualize the final result in Kibana. ''

I have run this query in sense and got an output. How to visualize this in Kibana. Kindly help

GET topbeat-2016.06.20/\_search  
{  
"size": 0,  
"aggs":{  
"bucket1":{  
"terms":{  
"script":"'bucket1'"  
},  
"aggs": {  
"bucket2":{  
"terms": {  
"script":"'bucket2'"  
}  
},  
"avg\_cpu":{  
"avg":{  
"field":"cpu.user\_p"  
}  
},  
"avg\_fs":{  
"avg":{  
"field":"fs.used\_p"  
}  
},  
"avg\_mem":{  
"avg":{  
"field":"mem.used\_p"  
}  
},  
"system\_health":{  
"bucket\_script": {  
"buckets\_path":{  
"avgcpu":"avg\_cpu",  
"avgmem":"avg\_mem",  
"avgfs":"avg\_fs"  
},  
"script": "if(avgcpu \> 0.8 || avgmem \> 0.6 || avgfs \> 0.5){2}else if(avgcpu \> 0.6 || avgmem \> 0.4 || avgfs \> 0.3){1}else{0}"  
}  
}  
}  
}  
}  
}

---

<div class="post-metadata">

### Author: ![shaunak](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/shaunak/32/6643_2.png) [@shaunak](https://discuss.elastic.co/u/shaunak)
#### Post date: [June 28, 2016, 5:55pm UTC](https://discuss.elastic.co/t/bucketed-query-in-kibana/54106/2 "2016-06-28T17:55:16Z")

</div>

Pipeline aggregations are not supported in Kibana yet ([https://github.com/elastic/kibana/issues/4584](https://github.com/elastic/kibana/issues/4584)). So it is currently not possible to visualize your query in Kibana.

---

<div class="post-metadata">

### Author: ![pvignesh92](https://avatars.discourse-cdn.com/v4/letter/p/bcef8e/32.png) [@pvignesh92](https://discuss.elastic.co/u/pvignesh92)
#### Post date: [June 29, 2016, 4:52am UTC](https://discuss.elastic.co/t/bucketed-query-in-kibana/54106/3 "2016-06-29T04:52:42Z")

</div>

Thanks Shaunak for confirming.

---

<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:48pm UTC](https://discuss.elastic.co/t/bucketed-query-in-kibana/54106/4 "2017-07-06T13:48:52Z")

</div>