Not plotting zero value correctly on line graph

[mmadala95]

Kibana 5.0.1:

Elasticsearch version 5.0.1:

Centos 6.8:

Chrome 59:

Hi,
line graph visualizations does not mark exact points at times ,just like the one in image below , Graph does not plot for value zero.Here the purple line must point to zero because no data is available at that point ,but still the graph maintains a constant value,What could be the reason ?

[thomasneirynck]

What value do you have on the X-axis? Is that a date-histogram?

[mmadala95]

Not exactly ,we have a field called incident month of type string on x axis , y axis we have unique count of those incident's ID

[thomasneirynck]

@ManojKumarMadala thanks,

Can you paste the ES-response? (open the spy-panel, little grey arrow bottom left).

Do you get the same result when using a bar chart?

[mmadala95]

Thanks @thomasneirynck

{
"took": 4,
"timed_out": false,
"_shards": {
"total": 5,
"successful": 5,
"failed": 0
},
"hits": {
"total": 1376,
"max_score": 0,
"hits": []
},
"aggregations": {
"2": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"3": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 2
},
"key": "Assist",
"doc_count": 2
}
]
},
"key": "S2",
"doc_count": 8
},
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 2
},
"key": "Assist",
"doc_count": 2
}
]
},
"key": "S1",
"doc_count": 3
}
]
},
"key": "2017-A-April",
"doc_count": 85
},
{
"3": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 3
},
"key": "Assist",
"doc_count": 3
}
]
},
"key": "S2",
"doc_count": 10
},
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 1
},
"key": "Assist",
"doc_count": 1
}
]
},
"key": "S1",
"doc_count": 3
}
]
},
"key": "2017-B-May",
"doc_count": 87
},
{
"3": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 2
},
"key": "Assist",
"doc_count": 2
}
]
},
"key": "S2",
"doc_count": 8
},
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
},
"key": "S1",
"doc_count": 1
}
]
},
"key": "2017-C-June",
"doc_count": 106
},
{
"3": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 4
},
"key": "Assist",
"doc_count": 4
}
]
},
"key": "S2",
"doc_count": 7
},
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 2
},
"key": "Assist",
"doc_count": 2
}
]
},
"key": "S1",
"doc_count": 2
}
]
},
"key": "2017-D-July",
"doc_count": 76
},
{
"3": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 1
},
"key": "Assist",
"doc_count": 1
}
]
},
"key": "S2",
"doc_count": 1
},
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 5
},
"key": "Assist",
"doc_count": 5
}
]
},
"key": "S1",
"doc_count": 5
}
]
},
"key": "2017-E-August",
"doc_count": 72
},
{
"3": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 2
},
"key": "Assist",
"doc_count": 2
}
]
},
"key": "S2",
"doc_count": 3
},
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 5
},
"key": "Assist",
"doc_count": 5
}
]
},
"key": "S1",
"doc_count": 5
}
]
},
"key": "2017-F-September",
"doc_count": 61
},
{
"3": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 9
},
"key": "Assist",
"doc_count": 9
}
]
},
"key": "S2",
"doc_count": 11
},
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 2
},
"key": "Assist",
"doc_count": 2
}
]
},
"key": "S1",
"doc_count": 2
}
]
},
"key": "2017-G-October",
"doc_count": 67
},
{
"3": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 3
},
"key": "Assist",
"doc_count": 3
}
]
},
"key": "S2",
"doc_count": 8
},
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 2
},
"key": "Assist",
"doc_count": 2
}
]
},
"key": "S1",
"doc_count": 2
}
]
},
"key": "2017-H-November",
"doc_count": 74
},
{
"3": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 1
},
"key": "Assist",
"doc_count": 1
}
]
},
"key": "S2",
"doc_count": 6
},
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 1
},
"key": "Assist",
"doc_count": 1
}
]
},
"key": "S1",
"doc_count": 1
}
]
},
"key": "2017-I-December",
"doc_count": 80
},
{
"3": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 1
},
"key": "Assist",
"doc_count": 1
}
]
},
"key": "S2",
"doc_count": 3
},
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 1
},
"key": "Assist",
"doc_count": 1
}
]
},
"key": "S1",
"doc_count": 1
}
]
},
"key": "2017-J-January",
"doc_count": 74
},
{
"3": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 3
},
"key": "Assist",
"doc_count": 3
}
]
},
"key": "S2",
"doc_count": 9
},
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 1
},
"key": "Assist",
"doc_count": 1
}
]
},
"key": "S1",
"doc_count": 1
}
]
},
"key": "2017-K-February",
"doc_count": 92
},
{
"3": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 5
},
"key": "Assist",
"doc_count": 5
}
]
},
"key": "S2",
"doc_count": 7
},
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 3
},
"key": "Assist",
"doc_count": 3
}
]
},
"key": "S1",
"doc_count": 3
}
]
},
"key": "2017-L-March",
"doc_count": 147
},
{
"3": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 5
},
"key": "Assist",
"doc_count": 5
}
]
},
"key": "S2",
"doc_count": 5
},
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 1
},
"key": "Assist",
"doc_count": 1
}
]
},
"key": "S1",
"doc_count": 1
}
]
},
"key": "2018-A-April",
"doc_count": 106
},
{
"3": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 4
},
"key": "Assist",
"doc_count": 4
}
]
},
"key": "S1",
"doc_count": 4
}
]
},
"key": "2018-B-May",
"doc_count": 90
},
{
"3": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 5
},
"key": "Assist",
"doc_count": 5
}
]
},
"key": "S2",
"doc_count": 5
},
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 2
},
"key": "Assist",
"doc_count": 2
}
]
},
"key": "S1",
"doc_count": 2
}
]
},
"key": "2018-C-June",
"doc_count": 70
},
{
"3": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 1
},
"key": "Assist",
"doc_count": 1
}
]
},
"key": "S2",
"doc_count": 1
},
{
"4": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"1": {
"value": 1
},
"key": "Assist",
"doc_count": 1
}
]
},
"key": "S1",
"doc_count": 1
}
]
},
"key": "2018-D-July",
"doc_count": 70
}
]
}
},
"status": 200
}

[mmadala95]

@thomasneirynck sorry i closed it by mistake

Bar Chart Seems to work fine, split bars shows no data for that month.But i have a requirement of Line Graph for this Particular set of data.
Thanks

[thomasneirynck]

Is this still occurring on the latest version of v5? In v5.3, there were some significant changes to the line and bar charts, which may have resolved this issue.

[thomasneirynck]

We should add the option for users here to select a fit function. e.g. drop to zero, connect, omit, similar how this can be configured in Timelion.

In the meantime, using a bar chart maybe an appropriate work-around.

[timroes]

I will close this with reference to #17717 which is the new ticket for fitting functions, which is the actual feature request here.