# Create rollup index job in Kibana, my time\_field in the date aggregation become a numeric instead of a date field

**URL:** <https://discuss.elastic.co/t/create-rollup-index-job-in-kibana-my-time-field-in-the-date-aggregation-become-a-numeric-instead-of-a-date-field/201823>\
**Category:** Kibana\
**Created:** [October 1, 2019, 2:20pm UTC](https://discuss.elastic.co/t/create-rollup-index-job-in-kibana-my-time-field-in-the-date-aggregation-become-a-numeric-instead-of-a-date-field/201823 "2019-10-01T14:20:02Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![cspRules](https://avatars.discourse-cdn.com/v4/letter/c/ea5d25/32.png) [@cspRules](https://discuss.elastic.co/u/cspRules)\
**Post date:** [October 1, 2019, 2:20pm UTC](https://discuss.elastic.co/t/create-rollup-index-job-in-kibana-my-time-field-in-the-date-aggregation-become-a-numeric-instead-of-a-date-field/201823/1 "2019-10-01T14:20:02Z")

</div>

HI,  
I am testing out rollup index job in Kibana. I have an index which have a date field and I use that in the rollup index job to create the date histogram. But in the rollup index, the date field that it rolled up to become a numeric (UTC #). When I try to use this rollup index in visualization such as vertical bars/lines etc, I can't choose date histogram for my X-axis as there is no more date field in the index. So, how to make the aggregated field into date or make the rollup index to have a date field?

---

<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:** [October 4, 2019, 11:17am UTC](https://discuss.elastic.co/t/create-rollup-index-job-in-kibana-my-time-field-in-the-date-aggregation-become-a-numeric-instead-of-a-date-field/201823/2 "2019-10-04T11:17:10Z")

</div>

Rollup indices will allow you to do date histograms only on the field set as time field in the creation of the rollup job. So you should set your field in this step of the wizard:

 ![date](https://us1.discourse-cdn.com/elastic/original/3X/d/b/dbfb1f34678cb15eaac0a70131dea76e6e266902.png)

---

<div class="post-metadata">

**Author:** ![cspRules](https://avatars.discourse-cdn.com/v4/letter/c/ea5d25/32.png) [@cspRules](https://discuss.elastic.co/u/cspRules)\
**Post date:** [October 4, 2019, 1:33pm UTC](https://discuss.elastic.co/t/create-rollup-index-job-in-kibana-my-time-field-in-the-date-aggregation-become-a-numeric-instead-of-a-date-field/201823/3 "2019-10-04T13:33:41Z")

</div>

I did. My field is called time\_stamp and is a date. But the one created in the roll up become a utc number field which I cannot use in the 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:** [November 1, 2019, 1:33pm UTC](https://discuss.elastic.co/t/create-rollup-index-job-in-kibana-my-time-field-in-the-date-aggregation-become-a-numeric-instead-of-a-date-field/201823/4 "2019-11-01T13:33:46Z")

</div>

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