# Kibana does not diplay elasticsearch index

**URL:** <https://discuss.elastic.co/t/kibana-does-not-diplay-elasticsearch-index/227343>\
**Category:** Kibana\
**Created:** [April 9, 2020, 2:24pm UTC](https://discuss.elastic.co/t/kibana-does-not-diplay-elasticsearch-index/227343 "2020-04-09T14:24:17Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Cristiano\_Corrado](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cristiano_corrado/32/66016_2.png) [@Cristiano\_Corrado](https://discuss.elastic.co/u/Cristiano_Corrado)\
**Post date:** [April 9, 2020, 2:24pm UTC](https://discuss.elastic.co/t/kibana-does-not-diplay-elasticsearch-index/227343/1 "2020-04-09T14:24:17Z")

</div>

Hello,

I am sure it has been asked million times but I couldn't find a solution for myself after hours of browsing.

I created an index in elasticsearch

```auto
PUT /coronavirus
{
  "settings" : {
        "number_of_shards" : 2
        
    },
  "mappings": {
      "properties": {
        "@timestamp": {
          "type": "date",
          "format": "date_hour_minute_second"
            },
        "Active_Cases": {
          "type": "float"
        },
        "Country": {
          "type": "text"
          
        },
        "Serious_Critical": {
          "type": "float"
        },
        "Tests_1M_POP": {
          "type": "float"
         
        },
        "Tot_Cases_1M_POP": {
          "type": "float"
        },
        "Tot_Deats_1M_POP": {
          "type": "float"
        },
        "Total_Cases": {
          "type": "float"
        },
        "Total_Deaths": {
          "type": "float"
        },
        "Total_Recovered": {
          "type": "float"
        
      }
    }
  }
}

```

The data mapping is correctly displayed when i import data through a python script using elasticsearch module everythin is fine.

If i query **GET /coronavirus/\_search**

I get the correct response with data:

```auto
{
  "took" : 2,
  "timed_out" : false,
  "_shards" : {
    "total" : 2,
    "successful" : 2,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 218,
      "relation" : "eq"
    },
    "max_score" : 1.0,
    "hits" : [
      {
        "_index" : "coronavirus",
        "_type" : "_doc",
        "_id" : "2o1JX3EBirWBsboeoYXp",
        "_score" : 1.0,
        "_source" : {
          "@timestamp" : "2020-04-09T15:13:13",
          "Country" : "Europe",
          "Total_Cases" : 757450.0,
          "Total_Deaths" : 62412.0,
          "Total_Recovered" : 174392.0,
          "Active_Cases" : 520646.0,
          "Serious_Critical" : 30515.0,
          "Tot_Cases_1M_POP" : 0.0,
          "Tot_Deats_1M_POP" : 0.0,
          "Tests_1M_POP" : 0.0
        }
      },

```

I create the index in Kibana and is correctly recognised with right fields and types:

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

When i try to discover data in Kibana i can't see anything I extended the time range for 1 year even if data just recently inserted.

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

Thanks a lot for any suggestions.

Best Regards,

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [April 9, 2020, 2:57pm UTC](https://discuss.elastic.co/t/kibana-does-not-diplay-elasticsearch-index/227343/2 "2020-04-09T14:57:24Z")

</div>

Could you try to change the time filter to a "to" date in the future:

 ![Screenshot 2020-04-09 at 16.53.28](https://us1.discourse-cdn.com/elastic/original/3X/9/c/9cf9d51264a50ce9180c4ea4e41f892e644db360.png)

I noticed that your date format in the mapping doesn't contain a time zone - in this case Elasticsearch will assume UTC. But Kibana is using the timezone from your local browser, depending on that timezone the mismatch could cause your data to be in the future (as far as Kibana is concerned).

You can either change your mapping (and ingested data) to contain the timezone (then Elasticsearch and Kibana will work together to show you the expected data) - for example `strict_date_time` or you could set your Kibana to UTC as well ( in Management \> advanced settings).

---

<div class="post-metadata">

**Author:** ![Cristiano\_Corrado](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cristiano_corrado/32/66016_2.png) [@Cristiano\_Corrado](https://discuss.elastic.co/u/Cristiano_Corrado)\
**Post date:** [April 9, 2020, 5:00pm UTC](https://discuss.elastic.co/t/kibana-does-not-diplay-elasticsearch-index/227343/3 "2020-04-09T17:00:03Z")

</div>

You are definitely right. It works setting the time range in future.  
How would I specify in the mapping the timezone?  
Thanks a lot.

---

<div class="post-metadata">

**Author:** ![Cristiano\_Corrado](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cristiano_corrado/32/66016_2.png) [@Cristiano\_Corrado](https://discuss.elastic.co/u/Cristiano_Corrado)\
**Post date:** [April 9, 2020, 5:04pm UTC](https://discuss.elastic.co/t/kibana-does-not-diplay-elasticsearch-index/227343/4 "2020-04-09T17:04:57Z")

</div>

ok i just used the datatime.datetime.utcnow() and it fixed it. Thanks a lot for pointing me in the right direction. solved.

---

<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:** [May 7, 2020, 5:05pm UTC](https://discuss.elastic.co/t/kibana-does-not-diplay-elasticsearch-index/227343/5 "2020-05-07T17:05:05Z")

</div>

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