# Kibana json aggregration query not working **URL:** \ **Category:** Kibana\ **Created:** [March 11, 2016, 1:06am UTC](https://discuss.elastic.co/t/kibana-json-aggregration-query-not-working/44098 "2016-03-11T01:06:24Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![sivakalyan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sivakalyan/32/8418_2.png) [@sivakalyan](https://discuss.elastic.co/u/sivakalyan)\ **Post date:** [March 11, 2016, 1:06am UTC](https://discuss.elastic.co/t/kibana-json-aggregration-query-not-working/44098/1 "2016-03-11T01:06:24Z")
Hi, I'm trying examples from [https://www.elastic.co/guide/en/elasticsearch/reference/current/\_executing\_aggregations.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/_executing_aggregations.html) to run searches on the banking data. The below json query works fine when I query elasticsearch using curl, but the same query (minified json format) throws an error in kibana. Elasticsearch: { "size": 0, "aggs": { "group\_by\_state": { "terms": { "field": "state" }, "aggs": { "average\_balance": { "avg": { "field": "balance" } } } } } } Kibana: {"size":0,"aggs":{"group\_by\_state":{"terms":{"field":"state"},"aggs":{"average\_balance":{"avg":{"field":"balance"}}}}}} Error: Request to Elasticsearch failed: {"error":{"root\_cause":[{"type":"query\_parsing\_exception","reason":"[\_na] query malformed, no field after start\_object","index":"logstash-2016.03.11","line":1,"col":283}],"type":"search\_phase\_execution\_exception","reason":"all shards failed","phase":"query","grouped":true,"failed\_shards":[{"shard":0,"index":"logstash-2016.03.11","node":"T0Ga\_5wIS16cHgzEQQNZEw","reason":{"type":"query\_parsing\_exception","reason":"[\_na] query malformed, no field after start\_object","index":"logstash-2016.03.11","line":1,"col":283}}]}} at [http://10.110.1.144:5601/bundles/kibana.bundle.js:79477:39](http://10.110.1.144:5601/bundles/kibana.bundle.js:79477:39) at Function.Promise.try ([http://10.110.1.144:5601/bundles/commons.bundle.js:60997:23](http://10.110.1.144:5601/bundles/commons.bundle.js:60997:23)) at [http://10.110.1.144:5601/bundles/commons.bundle.js:60966:31](http://10.110.1.144:5601/bundles/commons.bundle.js:60966:31) at Array.map (native) at Function.Promise.map ([http://10.110.1.144:5601/bundles/commons.bundle.js:60965:31](http://10.110.1.144:5601/bundles/commons.bundle.js:60965:31)) at callResponseHandlers ([http://10.110.1.144:5601/bundles/kibana.bundle.js:79449:23](http://10.110.1.144:5601/bundles/kibana.bundle.js:79449:23)) at [http://10.110.1.144:5601/bundles/kibana.bundle.js:78954:17](http://10.110.1.144:5601/bundles/kibana.bundle.js:78954:17) at processQueue ([http://10.110.1.144:5601/bundles/commons.bundle.js:42358:29](http://10.110.1.144:5601/bundles/commons.bundle.js:42358:29)) at [http://10.110.1.144:5601/bundles/commons.bundle.js:42374:28](http://10.110.1.144:5601/bundles/commons.bundle.js:42374:28) at Scope.$eval ([http://10.110.1.144:5601/bundles/commons.bundle.js:43602:29](http://10.110.1.144:5601/bundles/commons.bundle.js:43602:29)) Any idea how to fix this? Thanks, Siva ---
**Author:** ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)\ **Post date:** [March 11, 2016, 9:43pm UTC](https://discuss.elastic.co/t/kibana-json-aggregration-query-not-working/44098/2 "2016-03-11T21:43:47Z")
Where are you attempting to run this JSON? The main search bar? Or in the custom json field of a visualization? ---
**Author:** ![sivakalyan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sivakalyan/32/8418_2.png) [@sivakalyan](https://discuss.elastic.co/u/sivakalyan)\ **Post date:** [March 11, 2016, 10:17pm UTC](https://discuss.elastic.co/t/kibana-json-aggregration-query-not-working/44098/3 "2016-03-11T22:17:32Z")
In the main search bar. Thanks, Siva ---
**Author:** ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)\ **Post date:** [March 11, 2016, 10:44pm UTC](https://discuss.elastic.co/t/kibana-json-aggregration-query-not-working/44098/4 "2016-03-11T22:44:55Z")
Ah, that explains it. The search bar doesn't support aggregations, just search queries. If you want to do aggregations, that's what the Visualize tab is for. ---
**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/kibana-json-aggregration-query-not-working/44098/5 "2017-07-06T13:59:25Z")