# Kibana not showing any results in Discover with custom timestamp

**URL:** https://discuss.elastic.co/t/kibana-not-showing-any-results-in-discover-with-custom-timestamp/239273
**Category:** Kibana
**Created:** [June 30, 2020, 10:51am UTC](https://discuss.elastic.co/t/kibana-not-showing-any-results-in-discover-with-custom-timestamp/239273 "2020-06-30T10:51:54Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Terizian](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/terizian/32/71259_2.png) [@Terizian](https://discuss.elastic.co/u/Terizian)
#### Post date: [June 30, 2020, 10:51am UTC](https://discuss.elastic.co/t/kibana-not-showing-any-results-in-discover-with-custom-timestamp/239273/1 "2020-06-30T10:51:54Z")

</div>

Version: 7.7.1

I've pushed some data into Elasticsearch using the Python client library. Here is the mapping for my data that I got by running `GET rss-test/_mapping` in the Dev Tools Console:

```auto
    {
      "rss-test" : {
        "mappings" : {
          "properties" : {
            "content" : {
              "type" : "text",
              "fields" : {
                "keyword" : {
                  "type" : "keyword",
                  "ignore_above" : 256
                }
              }
            },
            "tags" : {
              "type" : "text",
              "fields" : {
                "keyword" : {
                  "type" : "keyword",
                  "ignore_above" : 256
                }
              }
            },
            "timestamp" : {
              "type" : "text",
              "fields" : {
                "keyword" : {
                  "type" : "keyword",
                  "ignore_above" : 256
                }
              }
            },
            "timestamp_dt" : {
              "type" : "date",
              "format" : "date_hour_minute_second"
            },
            "title" : {
              "type" : "text",
              "fields" : {
                "keyword" : {
                  "type" : "keyword",
                  "ignore_above" : 256
                }
              }
            },
            "url" : {
              "type" : "text",
              "fields" : {
                "keyword" : {
                  "type" : "keyword",
                  "ignore_above" : 256
                }
              }
            }
          }
        }
      }
    }

```

I've inserted one document and it can be seen using the search API. I've created an index pattern from the Kibana Management view as shown below:

 ![index_patter](https://us1.discourse-cdn.com/elastic/original/3X/1/0/10046182b41de5807ab6b138638f8da3c17fc939.png)

However, on the Discover tab, I can't see any data for this specific index pattern. I've expanded the time filter to 5 years. Here's a screenshot of that:

 ![Discover](https://us1.discourse-cdn.com/elastic/original/3X/1/4/1487d5a906ab70db31dba6a9f0904f192201d456.png)

When I create an index pattern without choosing the field timestamp\_dt as a time filter, I can see the data.

---

<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: [June 30, 2020, 2:40pm UTC](https://discuss.elastic.co/t/kibana-not-showing-any-results-in-discover-with-custom-timestamp/239273/2 "2020-06-30T14:40:39Z")

</div>

Could you expand your time range in Discover a few hours into the future? It's possible this is a timezone issue - as you are using `date_hour_minute_second` as format, Elasticsearch is assuming UTC as far as I know - if the date you are ingesting is not actually in the UTC time zone, it's possible it ends up getting indexed with an offset. It's always recommended to clearly specify the time zone in dates you are ingesting (or using a timezone-independent format like timestamps).

---

<div class="post-metadata">

### Author: ![Terizian](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/terizian/32/71259_2.png) [@Terizian](https://discuss.elastic.co/u/Terizian)
#### Post date: [June 30, 2020, 3:04pm UTC](https://discuss.elastic.co/t/kibana-not-showing-any-results-in-discover-with-custom-timestamp/239273/3 "2020-06-30T15:04:56Z")

</div>

Thanks for your response! You're absolutely right about the timezone issue. I'm currently in a UTC + 4 timezone and it wasn't showing the document as a result.

Do you have any specific recommendations for the date format?

---

<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: [June 30, 2020, 3:36pm UTC](https://discuss.elastic.co/t/kibana-not-showing-any-results-in-discover-with-custom-timestamp/239273/4 "2020-06-30T15:36:35Z")

</div>

If you can influence the incoming date format I recommend `strict_date_optional_time` ([https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-date-format.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-date-format.html)), it's following the ISO date standard which includes the time zone, so there's no ambiguity at any level.

---

<div class="post-metadata">

### Author: ![Terizian](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/terizian/32/71259_2.png) [@Terizian](https://discuss.elastic.co/u/Terizian)
#### Post date: [June 30, 2020, 3:57pm UTC](https://discuss.elastic.co/t/kibana-not-showing-any-results-in-discover-with-custom-timestamp/239273/5 "2020-06-30T15:57:32Z")

</div>

I could probably modify the date in my pipeline. Thanks for the advice. I'll apply it and see how it goes!

---

<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: [July 28, 2020, 3:57pm UTC](https://discuss.elastic.co/t/kibana-not-showing-any-results-in-discover-with-custom-timestamp/239273/6 "2020-07-28T15:57:33Z")

</div>

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