# Count of user who visited 3 days in a row
**URL:** https://discuss.elastic.co/t/count-of-user-who-visited-3-days-in-a-row/37026
**Category:** Elasticsearch
**Created:** [December 11, 2015, 11:59pm UTC](https://discuss.elastic.co/t/count-of-user-who-visited-3-days-in-a-row/37026 "2015-12-11T23:59:18Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@vjyanand](https://discuss.elastic.co/u/vjyanand)
#### Post date: [December 11, 2015, 11:59pm UTC](https://discuss.elastic.co/t/count-of-user-who-visited-3-days-in-a-row/37026/1 "2015-12-11T23:59:18Z")
I have elasticsearch documents like {"user":"a","timestamp":1449807786150}. Would like to query users who have timestamp for 3 consecutive days.
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [December 12, 2015, 2:02am UTC](https://discuss.elastic.co/t/count-of-user-who-visited-3-days-in-a-row/37026/2 "2015-12-12T02:02:13Z")
Ok, and do you want help with that, or something else.
---
### Author:  [@vjyanand](https://discuss.elastic.co/u/vjyanand)
#### Post date: [December 12, 2015, 2:19am UTC](https://discuss.elastic.co/t/count-of-user-who-visited-3-days-in-a-row/37026/3 "2015-12-12T02:19:40Z")
Yes, need help to query the data. What would be the DSL?
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [December 12, 2015, 2:29am UTC](https://discuss.elastic.co/t/count-of-user-who-visited-3-days-in-a-row/37026/4 "2015-12-12T02:29:45Z")
Try [https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-range-query.html#ranges-on-dates](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-range-query.html#ranges-on-dates)
---
### Author:  [@vjyanand](https://discuss.elastic.co/u/vjyanand)
#### Post date: [December 12, 2015, 5:21am UTC](https://discuss.elastic.co/t/count-of-user-who-visited-3-days-in-a-row/37026/5 "2015-12-12T05:21:33Z")
I understand we can use data range. But I want to get say "number of users who have logged in 3 consecutive days for month of December or number of users who have logged in n consecutive days in the last m days (m is always greater than n)" Thanks
---
### Author:  [@vjyanand](https://discuss.elastic.co/u/vjyanand)
#### Post date: [December 16, 2015, 12:17pm UTC](https://discuss.elastic.co/t/count-of-user-who-visited-3-days-in-a-row/37026/6 "2015-12-16T12:17:41Z")
Can someone please help me on this? Thanks
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 5, 2017, 11:30pm UTC](https://discuss.elastic.co/t/count-of-user-who-visited-3-days-in-a-row/37026/7 "2017-07-05T23:30:37Z")