# How to find count of each field in a elastic search document

**URL:** https://discuss.elastic.co/t/how-to-find-count-of-each-field-in-a-elastic-search-document/44416
**Category:** Elasticsearch
**Created:** [March 15, 2016, 9:54am UTC](https://discuss.elastic.co/t/how-to-find-count-of-each-field-in-a-elastic-search-document/44416 "2016-03-15T09:54:56Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Nitendra1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nitendra1/32/50142_2.png) [@Nitendra1](https://discuss.elastic.co/u/Nitendra1)
#### Post date: [March 15, 2016, 9:54am UTC](https://discuss.elastic.co/t/how-to-find-count-of-each-field-in-a-elastic-search-document/44416/1 "2016-03-15T09:54:57Z")

</div>

I have document like given below

{"host":"xxx",

"sessionId":"xxx",

"day1":"10",

"day2":"30",

"day3":"20",

"day4":"50",

"day5":"10",

"day6":"20",

"day7":"80"}

day field is dynamic and may or may not available for each day. want to write query to fetch all sessionId where occurrence of day field \> 4

for example given doc is not eligible for query result while above doc is eligible

{"host":"xxx",

"sessionId":"xxx",

"day1":"10",

"day2":"30",

"day6":"20",

"day7":"80"}

---

<div class="post-metadata">

### Author: ![ddorian43](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ddorian43/32/36093_2.png) [@ddorian43](https://discuss.elastic.co/u/ddorian43)
#### Post date: [March 15, 2016, 10:48am UTC](https://discuss.elastic.co/t/how-to-find-count-of-each-field-in-a-elastic-search-document/44416/2 "2016-03-15T10:48:13Z")

</div>

Hi,

Can you make a script, that has access to the \_source, and will just iterate and count the number of fields that start with "day" ?

---

<div class="post-metadata">

### Author: ![Nitendra1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nitendra1/32/50142_2.png) [@Nitendra1](https://discuss.elastic.co/u/Nitendra1)
#### Post date: [March 15, 2016, 4:09pm UTC](https://discuss.elastic.co/t/how-to-find-count-of-each-field-in-a-elastic-search-document/44416/3 "2016-03-15T16:09:43Z")

</div>

i am new in elasticsearch and need java code to count all the field start with "day".

---

<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:08pm UTC](https://discuss.elastic.co/t/how-to-find-count-of-each-field-in-a-elastic-search-document/44416/4 "2017-07-05T23:08:14Z")

</div>


