# Incorrect value\_count on a string value

**URL:** <https://discuss.elastic.co/t/incorrect-value-count-on-a-string-value/37302>\
**Category:** Elasticsearch\
**Created:** [December 16, 2015, 5:31am UTC](https://discuss.elastic.co/t/incorrect-value-count-on-a-string-value/37302 "2015-12-16T05:31:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ramesh](https://avatars.discourse-cdn.com/v4/letter/r/d07c76/32.png) [@ramesh](https://discuss.elastic.co/u/ramesh)\
**Post date:** [December 16, 2015, 5:31am UTC](https://discuss.elastic.co/t/incorrect-value-count-on-a-string-value/37302/1 "2015-12-16T05:31:14Z")

</div>

Hi,

I have 6 simple documents:

{"id":1,"sid":"adf6eb4f-35a0-4099-95d4-00ce3d984cf2","asid":"577ce6b0-b8b7-49af-8528-4e4797027a12","\_tid":"21"}  
{"id":1,"sid":"adf6eb4f-35a0-4099-95d4-00ce3d984cf2","asid":"577ce6b0-b8b7-49af-8528-4e4797027a12","\_tid":"21"}  
{"id":2,"sid":"abcdef","asid":"fedcba","\_tid":"21"}  
{"id":3,"sid":"ghijk","asid":"kjihg","\_tid":"21"}  
{"id":4,"sid":"lmnop","asid":"ponml","\_tid":"21"}  
{"id":5,"sid":"prstuv","asid":"vutsrp","\_tid":"21"}

I am running a value\_count aggregation on this dataset using:

curl -XGET '[http://poc02.transerainc.com:9200/test/csrs/\_search](http://poc02.transerainc.com:9200/test/csrs/_search)' -d '{"size":0,"aggregations":{"SUMMARY\_0\_sid":{"value\_count":{"field":"sid"}}}}'

I am expecting the results to be 6 but I am getting 14!  
{"took":3,"timed\_out":false,"\_shards":{"total":5,"successful":5,"failed":0},"hits":{"total":6,"max\_score":0.0,"hits":[]},"aggregations":{"SUMMARY\_0\_sid":{"value": **14** }}}

this seems to be an obvious error but what am I missing here?

Thanks,  
Ramesh.

---

<div class="post-metadata">

**Author:** ![cbuescher](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cbuescher/32/60402_2.png) [@cbuescher](https://discuss.elastic.co/u/cbuescher)\
**Post date:** [December 16, 2015, 11:40am UTC](https://discuss.elastic.co/t/incorrect-value-count-on-a-string-value/37302/2 "2015-12-16T11:40:54Z")

</div>

Hi,  
If you didn't define any mapping, the "sid" field will be mapped to an analyzed string field by default (see [dynamic mapping](https://www.elastic.co/guide/en/elasticsearch/reference/2.1/dynamic-field-mapping.html) for details). The default analyzer used is the Standard Analyzer which will split words containing the `-` character. So for your first two documents the "sid" fields will be indexed as five tokens, giving you 14 in total.

---

<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 5, 2017, 11:30pm UTC](https://discuss.elastic.co/t/incorrect-value-count-on-a-string-value/37302/3 "2017-07-05T23:30:38Z")

</div>