# Is there a way to efficiently get three layer aggrigations result in elasticsearch, where each layer is conditioned by above one
**URL:** https://discuss.elastic.co/t/is-there-a-way-to-efficiently-get-three-layer-aggrigations-result-in-elasticsearch-where-each-layer-is-conditioned-by-above-one/307788
**Category:** Elasticsearch
**Created:** [June 21, 2022, 5:35pm UTC](https://discuss.elastic.co/t/is-there-a-way-to-efficiently-get-three-layer-aggrigations-result-in-elasticsearch-where-each-layer-is-conditioned-by-above-one/307788 "2022-06-21T17:35:41Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@Robin\_Rawat](https://discuss.elastic.co/u/Robin_Rawat)
#### Post date: [June 21, 2022, 5:35pm UTC](https://discuss.elastic.co/t/is-there-a-way-to-efficiently-get-three-layer-aggrigations-result-in-elasticsearch-where-each-layer-is-conditioned-by-above-one/307788/1 "2022-06-21T17:35:41Z")
I am trying to get composite aggregation for certain feilds which are present in each document. These documents are stored in elastic. Format of each document is a json with below mentioned keys. **{"id","name","topic","bucket","key"}**
Now I want to get result in below format: **From documents, how much each topic count is, how much each bucket count is for each topic and how much key count is for each bucket.** Now I had thought of using three layer aggrigation query, but is real slow for api's. Could anyone suggest some better options.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 19, 2022, 5:36pm UTC](https://discuss.elastic.co/t/is-there-a-way-to-efficiently-get-three-layer-aggrigations-result-in-elasticsearch-where-each-layer-is-conditioned-by-above-one/307788/2 "2022-07-19T17:36:22Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.