# How to Achieving count(distinct(doc\['userId'\])) with facets script

**URL:** <https://discuss.elastic.co/t/how-to-achieving-count-distinct-doc-userid-with-facets-script/10763>\
**Category:** Elasticsearch\
**Created:** [February 16, 2013, 7:53pm UTC](https://discuss.elastic.co/t/how-to-achieving-count-distinct-doc-userid-with-facets-script/10763 "2013-02-16T19:53:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![saud\_rehman](https://avatars.discourse-cdn.com/v4/letter/s/848f3c/32.png) [@saud\_rehman](https://discuss.elastic.co/u/saud_rehman)\
**Post date:** [February 16, 2013, 7:53pm UTC](https://discuss.elastic.co/t/how-to-achieving-count-distinct-doc-userid-with-facets-script/10763/1 "2013-02-16T19:53:39Z")

</div>

{  
"query" : {  
"match\_all" : { }  
},  
"facets" : {  
"stats" : {  
"terms\_stats" : {  
"key\_field" : "tag",  
"value\_script" : "count(distinct(doc['num1'].value))"  
}  
}  
}  
}

---

<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, 2:51am UTC](https://discuss.elastic.co/t/how-to-achieving-count-distinct-doc-userid-with-facets-script/10763/2 "2017-07-06T02:51:11Z")

</div>