# Return a single document per user per hour
**URL:** https://discuss.elastic.co/t/return-a-single-document-per-user-per-hour/135182
**Category:** Elasticsearch
**Created:** [June 8, 2018, 5:22pm UTC](https://discuss.elastic.co/t/return-a-single-document-per-user-per-hour/135182 "2018-06-08T17:22:45Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@le\_John](https://discuss.elastic.co/u/le_John)
#### Post date: [June 8, 2018, 5:22pm UTC](https://discuss.elastic.co/t/return-a-single-document-per-user-per-hour/135182/1 "2018-06-08T17:22:45Z")
Is there a way to return a single document per hour?
Another way to describe what I'm after: I'm thinking of a "date histogram" type scenario, but within the query, not with aggregations.
The data is basically a table with users' activity per hour (timestamp), with some values associated with their activity recorded at each hour. They can be active in more than one way (resulting in multiple documents per hour), but for this query, I'd like to simply grab a single document with information per hour, for each user. Is this possible?
Thanks
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [June 8, 2018, 6:10pm UTC](https://discuss.elastic.co/t/return-a-single-document-per-user-per-hour/135182/2 "2018-06-08T18:10:34Z")
Which document would you grab though?
---
### Author:  [@le\_John](https://discuss.elastic.co/u/le_John)
#### Post date: [June 8, 2018, 6:16pm UTC](https://discuss.elastic.co/t/return-a-single-document-per-user-per-hour/135182/3 "2018-06-08T18:16:26Z")
In this case, it doesn't matter which document, just that I can grab a single one. Order doesn't matter, I just want to use some of the meta data in the other fields.
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [June 8, 2018, 8:56pm UTC](https://discuss.elastic.co/t/return-a-single-document-per-user-per-hour/135182/4 "2018-06-08T20:56:03Z")
What about just using a filtered query with a date range attached to it?
---
### Author:  [@le\_John](https://discuss.elastic.co/u/le_John)
#### Post date: [June 8, 2018, 10:48pm UTC](https://discuss.elastic.co/t/return-a-single-document-per-user-per-hour/135182/5 "2018-06-08T22:48:38Z")
The hour is kind of an arbitrary amount and I'm looking for something more scalable. In the future I might be looking for per minute data. I think something like top\_hits might be closer to what I'm looking for.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2018, 10:48pm UTC](https://discuss.elastic.co/t/return-a-single-document-per-user-per-hour/135182/6 "2018-07-06T22:48:40Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.