# How to perform facets on combination of fields?

**URL:** <https://discuss.elastic.co/t/how-to-perform-facets-on-combination-of-fields/25628>\
**Category:** Elasticsearch\
**Created:** [July 15, 2015, 1:14pm UTC](https://discuss.elastic.co/t/how-to-perform-facets-on-combination-of-fields/25628 "2015-07-15T13:14:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![pmodi791](https://avatars.discourse-cdn.com/v4/letter/p/53a042/32.png) [@pmodi791](https://discuss.elastic.co/u/pmodi791)\
**Post date:** [July 15, 2015, 1:14pm UTC](https://discuss.elastic.co/t/how-to-perform-facets-on-combination-of-fields/25628/1 "2015-07-15T13:14:27Z")

</div>

We want to perform facets on combination of fields.

For example:  
Lets consider, my index contains two columns: Auther and Books. And we want to perform facets on combination of fields. Below is the expected output.  
Auther Books Count  
abc pqw 10  
abc asd 20  
asd pqw 12

so, it's like abc and pqw combinations are 10 among all rows.

---

<div class="post-metadata">

**Author:** ![Pradeep\_Gowda](https://avatars.discourse-cdn.com/v4/letter/p/ebca7d/32.png) [@Pradeep\_Gowda](https://discuss.elastic.co/u/Pradeep_Gowda)\
**Post date:** [July 15, 2015, 9:59pm UTC](https://discuss.elastic.co/t/how-to-perform-facets-on-combination-of-fields/25628/2 "2015-07-15T21:59:36Z")

</div>

Did you try using script?

---

<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, 12:01am UTC](https://discuss.elastic.co/t/how-to-perform-facets-on-combination-of-fields/25628/3 "2017-07-06T00:01:09Z")

</div>