# Kibana reporting and aggregation **URL:** \ **Category:** Kibana\ **Created:** [June 1, 2018, 2:59am UTC](https://discuss.elastic.co/t/kibana-reporting-and-aggregation/134126 "2018-06-01T02:59:55Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![hborda](https://avatars.discourse-cdn.com/v4/letter/h/90ced4/32.png) [@hborda](https://discuss.elastic.co/u/hborda)\ **Post date:** [June 1, 2018, 2:59am UTC](https://discuss.elastic.co/t/kibana-reporting-and-aggregation/134126/1 "2018-06-01T02:59:55Z")
We have about 700,000 documents. Those documents have about 20 fields each. We would like to create a report/search that summarizes 5 of the 20 columns by two of other columns, Basically a a typical "select ... group by .....", the end result will be about 10,000 rows. We can't find a way to do it in Kibana. We are using the hosted version of [elastic.co](http://elastic.co). is it feasible to do what we want with Kibana? ---
**Author:** ![Bill\_McConaghy](https://avatars.discourse-cdn.com/v4/letter/b/ed655f/32.png) [@Bill\_McConaghy](https://discuss.elastic.co/u/Bill_McConaghy)\ **Post date:** [June 1, 2018, 4:39pm UTC](https://discuss.elastic.co/t/kibana-reporting-and-aggregation/134126/2 "2018-06-01T16:39:59Z")
You should be able to do a bucket aggregation, which roughly equates to a group by. [https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket.html) ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 29, 2018, 4:40pm UTC](https://discuss.elastic.co/t/kibana-reporting-and-aggregation/134126/3 "2018-06-29T16:40:09Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.