The line char date histogram different metrics are mis-aligned in the x-axis date

Elastic Stack Kibana
1

while changing Metrics Test Qty type to 'bar'
the bar char adds 2 dummy point before the date point.

image
image.png1720×876 164 KB

while changing the type to 'line', all the metrics point are aligned

image
image.png1736×904 184 KB

2

I got the workaround that is, set the 'bar' Chart Type Metric as the first one, then all the chart series will aligned with the first one. but this only can align the head but the bar char tail sometimes still missed.
the last date point is missed sometimes in the dashboard.

image
image.png1719×324 73 KB

the last one bar char is missed

image
image.png1737×887 136 KB

3

Hey @guanghaofan, which version of Kibana are you running? Also, can you export the problematic Visualization and attach it here?

4

My Kibana is 6.2.5-snapshot version

In this char, the last date point is missed in the bar: 2018-05-15, Qty 1426
here is the screen shot

image
image.png1740×904 128 KB

the request:

{
  "size": 0,
  "_source": {
    "excludes": []
  },
  "aggs": {
    "2": {
      "date_histogram": {
        "field": "lot_start_time",
        "interval": "1d",
        "time_zone": "Asia/Shanghai",
        "min_doc_count": 1
      },
      "aggs": {
        "1": {
          "avg": {
            "field": "cal_avg_net_test_time"
          }
        },
        "4": {
          "sum": {
            "field": "cal_total_tested_units"
          }
        }
      }
    }
  },
  "stored_fields": [
    "*"
  ],
  "script_fields": {},
  "docvalue_fields": [
    "@timestamp",
    "date",
    "lot_end_time",
    "lot_start_time",
    "system_date",
    "system_time",
    "updated_time"
  ],
  "query": {
    "bool": {
      "must": [
        {
          "match_all": {}
        },
        {
          "match_phrase": {
            "mfg_step": {
              "query": "FT1"
            }
          }
        },
        {
          "match_phrase": {
            "product": {
              "query": "ANUBIS"
            }
          }
        },
        {
          "range": {
            "lot_start_time": {
              "gte": 1524110742000,
              "lte": 1526456967000,
              "format": "epoch_millis"
            }
          }
        }
      ],
      "filter": [],
      "should": [],
      "must_not": []
    }
  }
}
5

And the converted table since the response is beyond the limit:
"lot_start_time per day",Qty,"Average cal_avg_net_test_time"
1524067200000,2027,"22.883224487304688"
1524153600000,5296,"23.65998020172119"
1524240000000,3681,"22.779942648751394"
1524326400000,3214,"23.12090015411377"
1524412800000,3858,"22.558071408952987"
1524499200000,2404,"22.687775135040283"
1524585600000,4815,"22.196462631225586"
1524672000000,6533,"23.50210018157959"
1524758400000,6182,"22.249309921264647"
1524844800000,6356,"21.75174026489258"
1524931200000,8029,"23.158120091756185"
1525017600000,6655,"22.96839244549091"
1525104000000,7019,"23.082909150557086"
1525190400000,6592,"23.098969239455002"
1525276800000,7307,"23.012973403930665"
1525363200000,6435,"22.794875144958496"
1525449600000,5761,"23.521509170532227"
1525536000000,7640,"22.157335826328822"
1525622400000,7115,"22.613776793846718"
1525708800000,6148,"22.67639992453835"
1525795200000,7035,"23.246050039927166"
1525881600000,4880,"23.57756699456109"
1525968000000,6868,"22.24150900407271"
1526054400000,3358,"24.151299794514973"
1526140800000,2415,"22.969619750976562"
1526227200000,2132,"22.477224826812744"
1526313600000,1426,"26.125600814819336"

6

Hey @guanghaofan, which version of Kibana are you running? Also, can you export the problematic Visualization and attach it here?

I think this also happens on version 6.3.0, this is a example that version:
here you can see the leading and the tail are not aligned across the bar chart and the line chart

image
image1724×899 138 KB

7

Another small issue:

the chart type are: bar-line-bar, you can see the two bars are placed partially overlapping.

image
image.png1730×899 136 KB

changing to : bar-bar-line, now this is the normal case!

image
image.png1727×894 140 KB

8

Hey @guanghaofan these seem like two separate bugs, would you mind creating two separate issues for these here

9

2 issues created: