# BST conversion on Kibana Visualization

**URL:** https://discuss.elastic.co/t/bst-conversion-on-kibana-visualization/239840
**Category:** Kibana
**Created:** [July 3, 2020, 5:27pm UTC](https://discuss.elastic.co/t/bst-conversion-on-kibana-visualization/239840 "2020-07-03T17:27:23Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Landong.Zuo](https://avatars.discourse-cdn.com/v4/letter/l/43a26b/32.png) [@Landong.Zuo](https://discuss.elastic.co/u/Landong.Zuo)
#### Post date: [July 3, 2020, 5:27pm UTC](https://discuss.elastic.co/t/bst-conversion-on-kibana-visualization/239840/1 "2020-07-03T17:27:23Z")

</div>

Hello,

I installed ELK V7.6.1 on an AWS Linux 2 EC2.  
When I ran a Data Histogram Aggregation in Kibana visualization with a time filter crossing over UTC and BST, e.g. from 2020-03-01T00:00:00.000 to 2020-04-01T00:00:00.000, the visualization showed duplicate records for 2020-03-29.  
|2020-03-28|95,767|  
|2020-03-29|99,609|  
|2020-03-29|139,228|  
|2020-03-30|144,467|  
|2020-03-31|1|

The Kibana request had a date range like following:

```auto
{ 
         "range": {
            "@timestamp": {
              "gte": "2020-03-01T00:00:00.000Z",
              "lte": "2020-03-31T23:00:00.000Z",
              "format": "strict_date_optional_time"
            }
          }
        }

```

The underneath response from ElasticSearch was like following:

```auto
{
          "key_as_string": "2020-03-28T00:00:00.000Z",
          "key": 1585353600000,
          "doc_count": 95767
        },
        {
          "key_as_string": "2020-03-29T00:00:00.000Z",
          "key": 1585440000000,
          "doc_count": 99609
        },
        {
          "key_as_string": "2020-03-30T00:00:00.000+01:00",
          "key": 1585522800000,
          "doc_count": 139228
        },
        {
          "key_as_string": "2020-03-31T00:00:00.000+01:00",
          "key": 1585609200000,
          "doc_count": 144467
        },
        {
          "key_as_string": "2020-04-01T00:00:00.000+01:00",
          "key": 1585695600000,
          "doc_count": 1
        }

```

Apparently, Kibana converted BST to UTC and display only the date part of converted UTC time with aggregation buckets. However, this conversion seems to be unwanted and visualization output is confusing.

Can someone take a look at this issue please?

Thanks,  
Landong Zuo

---

<div class="post-metadata">

### Author: ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)
#### Post date: [July 30, 2020, 9:34pm UTC](https://discuss.elastic.co/t/bst-conversion-on-kibana-visualization/239840/2 "2020-07-30T21:34:20Z")

</div>

Hello,

There is a parameter called **Timezone for date formatting** in your advanced settings under Kibana in management. You should be able to set it your preferred timeformat and Kibana will display time accordingly.

Thanks,  
Bhavya

---

<div class="post-metadata">

### Author: ![Landong.Zuo](https://avatars.discourse-cdn.com/v4/letter/l/43a26b/32.png) [@Landong.Zuo](https://discuss.elastic.co/u/Landong.Zuo)
#### Post date: [August 3, 2020, 9:49am UTC](https://discuss.elastic.co/t/bst-conversion-on-kibana-visualization/239840/3 "2020-08-03T09:49:11Z")

</div>

Thanks Bhavya,

Kibana works fine after changing the default time zone to UTC.

Regards,  
Landong

---

<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 31, 2020, 9:49am UTC](https://discuss.elastic.co/t/bst-conversion-on-kibana-visualization/239840/4 "2020-08-31T09:49:11Z")

</div>

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