# Can't see data from rollup index on visualizations

**URL:** <https://discuss.elastic.co/t/cant-see-data-from-rollup-index-on-visualizations/247060>\
**Category:** Kibana\
**Created:** [September 1, 2020, 7:51am UTC](https://discuss.elastic.co/t/cant-see-data-from-rollup-index-on-visualizations/247060 "2020-09-01T07:51:14Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Danylo](https://avatars.discourse-cdn.com/v4/letter/d/5f9b8f/32.png) [@Danylo](https://discuss.elastic.co/u/Danylo)\
**Post date:** [September 1, 2020, 7:51am UTC](https://discuss.elastic.co/t/cant-see-data-from-rollup-index-on-visualizations/247060/1 "2020-09-01T07:51:14Z")

</div>

Hi. I have elastic and kibana 7.8.0. I created few rollup jobs for get my old data more smaller and that jobs seems to b working in correct way. I can see this data on Discover page, but once I go to create any visualization it seems that there are no data in index. Was trying to find some documentation about this but there are very few information about how visualize rollup indexes. Can somebody help me with this?

One of my metricbeat index rollup jobs have this config:

```auto
    {
      "config": {
        "id": "rollup-metricbeat-processes-V2",
        "index_pattern": "metricbeat-*",
        "rollup_index": "summary-metricbeat-processes",
        "cron": "0 30 3 1/1 * ?",
        "groups": {
          "date_histogram": {
            "fixed_interval": "60m",
            "field": "@timestamp",
            "delay": "24h",
            "time_zone": "UTC"
          },
          "terms": {
            "fields": [
              "host.name",
              "process.name",
              "user.name"
            ]
          }
        },
        "metrics": [
          {
            "field": "system.process.cpu.total.pct",
            "metrics": [
              "avg",
              "max",
              "min",
              "value_count"
            ]
          },
          {
            "field": "system.process.memory.size",
            "metrics": [
              "avg",
              "max",
              "min",
              "value_count"
            ]
          }
        ],
        "timeout": "20s",
        "page_size": 1000
      },
      "status": {
        "job_state": "started",
        "current_position": {
          "@timestamp.date_histogram": 1598839200000,
          "host.name.terms": "some host name",
          "process.name.terms": "sqlservr.exe",
          "user.name.terms": "NT SERVICE\\MSSQLSERVER"
        },
        "upgraded_doc_id": true
      },
      "stats": {
        "pages_processed": 1880,
        "documents_processed": 910509698,
        "rollups_indexed": 1841278,
        "trigger_count": 24,
        "index_time_in_ms": 956837,
        "index_total": 1856,
        "index_failures": 0,
        "search_time_in_ms": 53702703,
        "search_total": 1880,
        "search_failures": 0,
        "processing_time_in_ms": 40147,
        "processing_total": 1880
      }
    }

```

This is how it looks like in Discover page

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/2/22bcf5223a06bf71a0ecd134a0cce1aceb6f0e02.png)

And this is how it looks like in a table visualization

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/6/d67c930460756b4a0220d58c26f5af4160535dc3.png)

What I'm doing wrong?

---

<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:** [September 4, 2020, 5:52am UTC](https://discuss.elastic.co/t/cant-see-data-from-rollup-index-on-visualizations/247060/2 "2020-09-04T05:52:19Z")

</div>

cc @cjcenizal whenever u get a chance can you shed some light here plz?

---

<div class="post-metadata">

**Author:** ![Danylo](https://avatars.discourse-cdn.com/v4/letter/d/5f9b8f/32.png) [@Danylo](https://discuss.elastic.co/u/Danylo)\
**Post date:** [September 8, 2020, 8:41am UTC](https://discuss.elastic.co/t/cant-see-data-from-rollup-index-on-visualizations/247060/3 "2020-09-08T08:41:48Z")

</div>

Any suggestions to resolve this problem? Or it just impossible and I shouldn't visualize rollup indexes?

---

<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:** [October 6, 2020, 8:41am UTC](https://discuss.elastic.co/t/cant-see-data-from-rollup-index-on-visualizations/247060/4 "2020-10-06T08:41:58Z")

</div>

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