# Kibana discover chart section not showing correct time

**URL:** <https://discuss.elastic.co/t/kibana-discover-chart-section-not-showing-correct-time/344201>\
**Category:** Kibana\
**Created:** [October 2, 2023, 2:47am UTC](https://discuss.elastic.co/t/kibana-discover-chart-section-not-showing-correct-time/344201 "2023-10-02T02:47:12Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Geeboy](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/geeboy/32/121876_2.png) [@Geeboy](https://discuss.elastic.co/u/Geeboy)\
**Post date:** [October 2, 2023, 2:47am UTC](https://discuss.elastic.co/t/kibana-discover-chart-section-not-showing-correct-time/344201/1 "2023-10-02T02:47:12Z")

</div>

good day,

my script in the backend/source server is running hourly. The behavior of my script will run every hour to capture the previous hour count. my concern is this discover chart (green bar) why it is showing 0800 time only with 2 values (1000H and 1100H)? what I though was 1 value/count for 1000H and 1 for 1100H time. I mean like 1 value for every hour.

for this sample image,  
first run at 1000H to capture 0900H to 0959H of count.  
2nd run at 1100H to capture 1000H to 1059H of count.

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

thank you

---

<div class="post-metadata">

**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\
**Post date:** [October 2, 2023, 10:35am UTC](https://discuss.elastic.co/t/kibana-discover-chart-section-not-showing-correct-time/344201/2 "2023-10-02T10:35:25Z")

</div>

Hi @Geeboy

If you edit the visualization and open the inspector to the `Request` tab, can you see the correct timestamps in the response?

---

<div class="post-metadata">

**Author:** ![Geeboy](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/geeboy/32/121876_2.png) [@Geeboy](https://discuss.elastic.co/u/Geeboy)\
**Post date:** [October 2, 2023, 11:55pm UTC](https://discuss.elastic.co/t/kibana-discover-chart-section-not-showing-correct-time/344201/3 "2023-10-02T23:55:19Z")

</div>

good day Sir @Marco_Liberati,

Im new to ES, fluentd and kibana, May I request for more steps how to edit the visualization and open the inspector to the `Request` tab? thank you very much Sir.

---

<div class="post-metadata">

**Author:** ![Geeboy](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/geeboy/32/121876_2.png) [@Geeboy](https://discuss.elastic.co/u/Geeboy)\
**Post date:** [October 3, 2023, 5:25am UTC](https://discuss.elastic.co/t/kibana-discover-chart-section-not-showing-correct-time/344201/4 "2023-10-03T05:25:35Z")

</div>

I need to query "last 6 hours" just to view all 13 data. the red line is my actual time. how to change this to hourly? because all 13 data is in 0800 time slot. for your guidance on this please. thank you

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

template:

```auto
{
  "_source": {
    "enabled": true
  },
  "properties": {
    "DATE": {
      "format": "yyyy-MM-dd",
      "index": true,
      "ignore_malformed": false,
      "store": false,
      "type": "date",
      "doc_values": true
    },
    "tailed_path": {
      "type": "text",
      "fields": {
        "keyword": {
          "ignore_above": 256,
          "type": "keyword"
        }
      }
    },
    "TransactionCount": {
      "type": "integer"
    }
  }
}

```

Data views of "Date"

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

sample logs from source:  
2023-10-03-09 3341  
2023-10-03-10 2111  
2023-10-03-11 4229  
2023-10-03-12 121  
2023-10-03-13 2957

---

<div class="post-metadata">

**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\
**Post date:** [October 3, 2023, 7:04am UTC](https://discuss.elastic.co/t/kibana-discover-chart-section-not-showing-correct-time/344201/5 "2023-10-03T07:04:38Z")

</div>

From Discover click the `Edit visualization` button on the right hand side:

 ![Screenshot 2023-10-03 at 09.02.38](https://us1.discourse-cdn.com/elastic/original/3X/0/1/01e648e59cbd35f7599285fdd578775ca0ceb113.png)

Now in Lens click on the `Inspect` button and then the `Request` dropdown:

 ![Screenshot 2023-10-03 at 09.02.55](https://us1.discourse-cdn.com/elastic/original/3X/a/c/accaf3257c85bc8b782a8ccae4cfbe5b0ec746bb.png)  
 ![Screenshot 2023-10-03 at 09.02.48](https://us1.discourse-cdn.com/elastic/original/3X/d/a/da867d6678de1e27bb87db8ef5864119a928f4d3.png)

Then the response tab:

![Screenshot 2023-10-03 at 09.03.06](https://us1.discourse-cdn.com/elastic/original/3X/4/5/45146e560ccab77508b27a13cbff642de9d66562.png)

Here there's the raw response from Elasticsearch. There should be present all date histogram buckets used for charting.

---

<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 31, 2023, 7:05am UTC](https://discuss.elastic.co/t/kibana-discover-chart-section-not-showing-correct-time/344201/6 "2023-10-31T07:05:13Z")

</div>

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