# Date histogram visualization of a sub-aggregation

**URL:** <https://discuss.elastic.co/t/date-histogram-visualization-of-a-sub-aggregation/84922>\
**Category:** Kibana\
**Created:** [May 8, 2017, 11:21am UTC](https://discuss.elastic.co/t/date-histogram-visualization-of-a-sub-aggregation/84922 "2017-05-08T11:21:03Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mandycoston](https://avatars.discourse-cdn.com/v4/letter/m/ea666f/32.png) [@mandycoston](https://discuss.elastic.co/u/mandycoston)\
**Post date:** [May 8, 2017, 11:21am UTC](https://discuss.elastic.co/t/date-histogram-visualization-of-a-sub-aggregation/84922/1 "2017-05-08T11:21:03Z")

</div>

Hi,

I have documents with fields "publish\_date" and "writer\_id". I'd like a date histogram of the first published article by each writer\_id. Can I visualize this on Kibana?

{  
"size" : 0,  
"aggs": {  
"first\_post": {  
"date\_histogram": {  
"field": "publish\_date",  
"interval": "week",  
"format": "yyyy-MM-dd"  
},  
"aggs": {  
"authors" : {  
"terms": {"field": "writer\_id"},

```
    		"aggs" : {
    			"min_date" : {"min": {"field": "publish_date"}}
    		}
		}
	}
}

```

}  
}

---

<div class="post-metadata">

**Author:** ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)\
**Post date:** [May 8, 2017, 6:51pm UTC](https://discuss.elastic.co/t/date-histogram-visualization-of-a-sub-aggregation/84922/2 "2017-05-08T18:51:27Z")

</div>

Hi

You would have to get the minimum-date for each published article by running the `Min metric` for their date field, with terms being each article . Not sure how/why you would like to plot this on a date-histogram.  
I think you would first have to make sure the `publish_date` is a `date field` in Kibana (not a string) and I think it has to be the `time field` of the index pattern. It will depend on the schema of your data.

Thanks  
Rashmi

---

<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:** [June 5, 2017, 7:05pm UTC](https://discuss.elastic.co/t/date-histogram-visualization-of-a-sub-aggregation/84922/3 "2017-06-05T19:05:55Z")

</div>

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