# Get continuous timestamps of given interval in kibana rollup jobs

**URL:** <https://discuss.elastic.co/t/get-continuous-timestamps-of-given-interval-in-kibana-rollup-jobs/191570>\
**Category:** Kibana\
**Created:** [July 22, 2019, 5:10am UTC](https://discuss.elastic.co/t/get-continuous-timestamps-of-given-interval-in-kibana-rollup-jobs/191570 "2019-07-22T05:10:40Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![isharamadhawa](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/isharamadhawa/32/68006_2.png) [@isharamadhawa](https://discuss.elastic.co/u/isharamadhawa)\
**Post date:** [July 22, 2019, 5:10am UTC](https://discuss.elastic.co/t/get-continuous-timestamps-of-given-interval-in-kibana-rollup-jobs/191570/1 "2019-07-22T05:10:40Z")

</div>

I have created a rollup job in `Kibana` as follows:

```auto
{
    "id": "test-job",
    "index_pattern": "test-index",
    "rollup_index": "test-rollup",
    "cron": "0 * * * * ?",
    "groups": {
      "date_histogram": {
        "interval": "1s",
        "field": "@timestamp",
        "time_zone": "Asia/Colombo"
      },
      "terms": {
        "fields": [
          "transaction"
        ]
      }
    },
    "metrics": [
      {
        "field": "@timestamp",
        "metrics": [
          "value_count"
        ]
      }
    ],
    "timeout": "20s",
    "page_size": 1000
  }

```

Result is as I expected though it doesn't include time stamps which don't include any data on them.

As an example timestamp second of `07:15:45.000` doesn't include any data. So in rollup data also it doesn't include any data.

![Screenshot%20from%202019-07-22%2010-18-56](https://us1.discourse-cdn.com/elastic/original/3X/a/d/adcb40453161bfb84f2dc9e861a366aa4b708ac6.png)

But what I want is though any timestamp doesn't include any data it should indicate relevant counts as `0` . Timestamps should appear continuously. There shouldn't be any gaps.

Is this possible using current features of Rollup jobs in Kibana? If yes How could I achieve this? Hope you understand the question.

---

<div class="post-metadata">

**Author:** ![LizaD](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lizad/32/51074_2.png) [@LizaD](https://discuss.elastic.co/u/LizaD)\
**Post date:** [July 22, 2019, 3:33pm UTC](https://discuss.elastic.co/t/get-continuous-timestamps-of-given-interval-in-kibana-rollup-jobs/191570/2 "2019-07-22T15:33:45Z")

</div>

Hi @isharamadhawa, maybe @polyfractal can help answer.

Thanks,  
Liza

---

<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:** [August 19, 2019, 3:33pm UTC](https://discuss.elastic.co/t/get-continuous-timestamps-of-given-interval-in-kibana-rollup-jobs/191570/3 "2019-08-19T15:33:48Z")

</div>

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