# Find unique hours from date field

**URL:** <https://discuss.elastic.co/t/find-unique-hours-from-date-field/186588>\
**Category:** Kibana\
**Created:** [June 20, 2019, 5:19am UTC](https://discuss.elastic.co/t/find-unique-hours-from-date-field/186588 "2019-06-20T05:19:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![A\_google\_user](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/a_google_user/32/46709_2.png) [@A\_google\_user](https://discuss.elastic.co/u/A_google_user)\
**Post date:** [June 20, 2019, 5:19am UTC](https://discuss.elastic.co/t/find-unique-hours-from-date-field/186588/1 "2019-06-20T05:19:54Z")

</div>

I have time-stamp field (yyyy-mm-dd T hh:mm:ss). I want to count how many different hours are present in given day. How to do that in kibana ?

For example.  
Doc1=  
{  
name="heart\_beat"  
date="2019-06-05 T 12:10:00"  
}  
Doc2=  
{  
name="heart\_beat"  
date="2019-06-05 T 09:10:00"  
}  
Doc3=  
{  
name="heart\_beat"  
date="2019-06-05 T 12:15:00"  
}  
Doc4=  
{  
name="heart\_beat"  
date="2019-06-05 T 07:10:00"  
}

So answer will be 3

07,09 and 12

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [June 20, 2019, 11:01am UTC](https://discuss.elastic.co/t/find-unique-hours-from-date-field/186588/2 "2019-06-20T11:01:51Z")

</div>

for doing that you'd want to have a day/date and a hour field in your document (either from ingest, either via scripted fields), then you would have a cardinality metric on the hour field, with the date field in as the X-axis in your histogram.

---

<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 18, 2019, 11:02am UTC](https://discuss.elastic.co/t/find-unique-hours-from-date-field/186588/3 "2019-07-18T11:02:10Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.