Visualization not showing lines correctly

Hello,

according to closed ticket Dashboard not showing lines correctly.

We have imported a lot of visualizations (created under kibana version 5.0.0) into kibana version 5.5.0.
After that we have a strange behavior:

Some data points of the imported visualization (created under version 5.0) are NOT connected as line (see right side of uploaded dashboard picture)

I have created the same visualization under 5.5.0 and all data points are connected as line (see left side of uploaded dashboard picture)

Both visualizations are pointing to the same es-data (kibana index).

We have to migrate over 200 (line-chart) visualizations and don't want to create it all from scratch again.

How to migrate this visualizations to avoid the described problem?

Thank you in advance!

Here is the exported JSON for visualization "aaa_testdu_v_5_0":

[{"_id": "97aeea20-adb8-11e7-99a6-b5daf0357da2","_type": "visualization","_source": {"title": "aaa_testdu_v_5_0","visState": "{\"aggs\":[{\"enabled\":true,\"id\":\"1\",\"params\":{\"customLabel\":\"MQ-2-PAF-UIC\",\"field\":\"inputKpi.mq2.MQ_2_PAF_UIC\"},\"schema\":\"metric\",\"type\":\"avg\"},{\"enabled\":true,\"id\":\"2\",\"params\":{\"customInterval\":\"2h\",\"customLabel\":\"Verkehrstag\",\"extended_bounds\":{},\"field\":\"inputKpi.verkehrstag\",\"interval\":\"d\",\"min_doc_count\":1},\"schema\":\"segment\",\"type\":\"date_histogram\"},{\"enabled\":true,\"id\":\"3\",\"params\":{\"customLabel\":\"MQ-2-PAF-NSS\",\"field\":\"inputKpi.mq2.MQ_2_PAF_NSS\"},\"schema\":\"metric\",\"type\":\"avg\"},{\"enabled\":true,\"id\":\"4\",\"params\":{\"customLabel\":\"MQ-2-PAF-NSS-UIC\",\"field\":\"inputKpi.mq2.MQ_2_PAF_NSS_UIC\"},\"schema\":\"metric\",\"type\":\"avg\"},{\"enabled\":true,\"id\":\"5\",\"params\":{\"customLabel\":\"MQ-2-NSS-UIC\",\"field\":\"inputKpi.mq2.MQ_2_NSS_UIC\"},\"schema\":\"metric\",\"type\":\"avg\"},{\"enabled\":true,\"id\":\"6\",\"params\":{\"customLabel\":\"MQ-2-UIC-NSS\",\"field\":\"inputKpi.mq2.MQ_2_UIC_NSS\"},\"schema\":\"metric\",\"type\":\"avg\"},{\"enabled\":true,\"id\":\"10\",\"params\":{\"customLabel\":\"MQ-2-NSS-PAF-ICE\",\"field\":\"inputKpi.mq2.MQ_2_NSS_PAF_ICE\"},\"schema\":\"metric\",\"type\":\"avg\"},{\"enabled\":true,\"id\":\"11\",\"params\":{\"customLabel\":\"MQ-2-NSS-UIC-ICE\",\"field\":\"inputKpi.mq2.MQ_2_NSS_UIC_ICE\"},\"schema\":\"metric\",\"type\":\"avg\"},{\"enabled\":true,\"id\":\"12\",\"params\":{\"customLabel\":\"MQ-2-NSS-UIC-PAF-ICE\",\"field\":\"inputKpi.mq2.MQ_2_NSS_UIC_PAF_ICE\"},\"schema\":\"metric\",\"type\":\"avg\"}],\"listeners\":{},\"params\":{\"addLegend\":true,\"addTimeMarker\":false,\"addTooltip\":true,\"categoryAxes\":[{\"id\":\"CategoryAxis-1\",\"labels\":{\"show\":true,\"truncate\":100},\"position\":\"bottom\",\"scale\":{\"type\":\"linear\"},\"show\":true,\"style\":{},\"title\":{},\"type\":\"category\"}],\"defaultYExtents\":true,\"drawLinesBetweenPoints\":true,\"grid\":{\"categoryLines\":false,\"style\":{\"color\":\"#eee\"}},\"interpolate\":\"linear\",\"legendPosition\":\"right\",\"radiusRatio\":9,\"scale\":\"linear\",\"seriesParams\":[{\"data\":{\"id\":\"1\",\"label\":\"Count\"},\"drawLinesBetweenPoints\":true,\"mode\":\"normal\",\"show\":\"true\",\"showCircles\":true,\"type\":\"line\",\"valueAxis\":\"ValueAxis-1\"}],\"setYExtents\":false,\"shareYAxis\":true,\"showCircles\":true,\"smoothLines\":false,\"times\":[],\"valueAxes\":[{\"id\":\"ValueAxis-1\",\"labels\":{\"filter\":false,\"rotate\":0,\"show\":true,\"truncate\":100},\"name\":\"LeftAxis-1\",\"position\":\"left\",\"scale\":{\"mode\":\"normal\",\"type\":\"linear\"},\"show\":true,\"style\":{},\"title\":{\"text\":\"Count\"},\"type\":\"value\"}],\"yAxis\":{}},\"title\":\"aaa_testdu_v_5_0\",\"type\":\"line\"}","uiStateJSON": "{\"vis\":{\"colors\":{\"MQ-2-PAF-UIC\":\"#6D1F62\",\"MQ-2-PAF-NSS\":\"#962D82\",\"MQ-2-PAF-NSS-UIC\":\"#BA43A9\",\"MQ-2-NSS-UIC\":\"#C15C17\",\"MQ-2-UIC-NSS\":\"#F9934E\",\"MQ-2-PAF-UIC-FV\":\"#0A437C\",\"MQ-2-PAF-NSS-FV\":\"#1F78C1\",\"MQ-2-NSS-PAF-ICE\":\"#508642\",\"MQ-2-NSS-UIC-ICE\":\"#7EB26D\",\"MQ-2-NSS-UIC-PAF-ICE\":\"#B7DBAB\",\"MQ-2-PAF-NSS-UIC-FV\":\"#82B5D8\"}}}","description": "","version": 1,"kibanaSavedObjectMeta": {"searchSourceJSON": "{\"index\":\"inputkpi\",\"query\":{\"query_string\":{\"query\":\"*\",\"analyze_wildcard\":true}},\"filter\":[]}"}}}]

Here is the exported JSON for visualization "aaa_testdu_v_5_5":

[{"_id": "43abae20-adb5-11e7-99a6-b5daf0357da2","_type": "visualization","_source": {"title": "aaa_testdu_v_5_5","visState": "{\"title\":\"aaa_testdu_v_5_5\",\"type\":\"line\",\"params\":{\"grid\":{\"categoryLines\":false,\"style\":{\"color\":\"#eee\"}},\"categoryAxes\":[{\"id\":\"CategoryAxis-1\",\"type\":\"category\",\"position\":\"bottom\",\"show\":true,\"style\":{},\"scale\":{\"type\":\"linear\"},\"labels\":{\"show\":true,\"truncate\":100},\"title\":{\"text\":\"Verkehrstag\"}}],\"valueAxes\":[{\"id\":\"ValueAxis-1\",\"name\":\"LeftAxis-1\",\"type\":\"value\",\"position\":\"left\",\"show\":true,\"style\":{},\"scale\":{\"type\":\"linear\",\"mode\":\"normal\"},\"labels\":{\"show\":true,\"rotate\":0,\"filter\":false,\"truncate\":100},\"title\":{\"text\":\"\"}}],\"seriesParams\":[{\"show\":\"true\",\"type\":\"line\",\"mode\":\"normal\",\"data\":{\"label\":\"MQ-2-PAF-UIC\",\"id\":\"1\"},\"valueAxis\":\"ValueAxis-1\",\"drawLinesBetweenPoints\":true,\"showCircles\":true},{\"show\":true,\"mode\":\"normal\",\"type\":\"line\",\"drawLinesBetweenPoints\":true,\"showCircles\":true,\"interpolate\":\"linear\",\"lineWidth\":2,\"data\":{\"id\":\"3\",\"label\":\"MQ-2-PAF-NSS\"},\"valueAxis\":\"ValueAxis-1\"},{\"show\":true,\"mode\":\"normal\",\"type\":\"line\",\"drawLinesBetweenPoints\":true,\"showCircles\":true,\"interpolate\":\"linear\",\"lineWidth\":2,\"data\":{\"id\":\"4\",\"label\":\"MQ-2-PAF-NSS-UIC\"},\"valueAxis\":\"ValueAxis-1\"},{\"show\":true,\"mode\":\"normal\",\"type\":\"line\",\"drawLinesBetweenPoints\":true,\"showCircles\":true,\"interpolate\":\"linear\",\"lineWidth\":2,\"data\":{\"id\":\"5\",\"label\":\"MQ-2-NSS-UIC\"},\"valueAxis\":\"ValueAxis-1\"},{\"show\":true,\"mode\":\"normal\",\"type\":\"line\",\"drawLinesBetweenPoints\":true,\"showCircles\":true,\"interpolate\":\"linear\",\"lineWidth\":2,\"data\":{\"id\":\"6\",\"label\":\"MQ-2-UIC-NSS\"},\"valueAxis\":\"ValueAxis-1\"},{\"show\":true,\"mode\":\"normal\",\"type\":\"line\",\"drawLinesBetweenPoints\":true,\"showCircles\":true,\"interpolate\":\"linear\",\"lineWidth\":2,\"data\":{\"id\":\"7\",\"label\":\"MQ-2-NSS-PAF-ICE\"},\"valueAxis\":\"ValueAxis-1\"},{\"show\":true,\"mode\":\"normal\",\"type\":\"line\",\"drawLinesBetweenPoints\":true,\"showCircles\":true,\"interpolate\":\"linear\",\"lineWidth\":2,\"data\":{\"id\":\"8\",\"label\":\"MQ-2-NSS-UIC-ICE\"},\"valueAxis\":\"ValueAxis-1\"},{\"show\":true,\"mode\":\"normal\",\"type\":\"line\",\"drawLinesBetweenPoints\":true,\"showCircles\":true,\"interpolate\":\"linear\",\"lineWidth\":2,\"data\":{\"id\":\"9\",\"label\":\"MQ-2-NSS-UIC-PAF-ICE\"},\"valueAxis\":\"ValueAxis-1\"}],\"addTooltip\":true,\"addLegend\":true,\"legendPosition\":\"right\",\"times\":[],\"addTimeMarker\":false},\"aggs\":[{\"id\":\"1\",\"enabled\":true,\"type\":\"avg\",\"schema\":\"metric\",\"params\":{\"field\":\"inputKpi.mq2.MQ_2_PAF_UIC\",\"customLabel\":\"MQ-2-PAF-UIC\"}},{\"id\":\"2\",\"enabled\":true,\"type\":\"date_histogram\",\"schema\":\"segment\",\"params\":{\"field\":\"inputKpi.verkehrstag\",\"interval\":\"d\",\"customInterval\":\"2h\",\"min_doc_count\":1,\"extended_bounds\":{},\"customLabel\":\"Verkehrstag\"}},{\"id\":\"3\",\"enabled\":true,\"type\":\"avg\",\"schema\":\"metric\",\"params\":{\"field\":\"inputKpi.mq2.MQ_2_PAF_NSS\",\"customLabel\":\"MQ-2-PAF-NSS\"}},{\"id\":\"4\",\"enabled\":true,\"type\":\"avg\",\"schema\":\"metric\",\"params\":{\"field\":\"inputKpi.mq2.MQ_2_PAF_NSS_UIC\",\"customLabel\":\"MQ-2-PAF-NSS-UIC\"}},{\"id\":\"5\",\"enabled\":true,\"type\":\"avg\",\"schema\":\"metric\",\"params\":{\"field\":\"inputKpi.mq2.MQ_2_NSS_UIC\",\"customLabel\":\"MQ-2-NSS-UIC\"}},{\"id\":\"6\",\"enabled\":true,\"type\":\"avg\",\"schema\":\"metric\",\"params\":{\"field\":\"inputKpi.mq2.MQ_2_UIC_NSS\",\"customLabel\":\"MQ-2-UIC-NSS\"}},{\"id\":\"7\",\"enabled\":true,\"type\":\"avg\",\"schema\":\"metric\",\"params\":{\"field\":\"inputKpi.mq2.MQ_2_NSS_PAF_ICE\",\"customLabel\":\"MQ-2-NSS-PAF-ICE\"}},{\"id\":\"8\",\"enabled\":true,\"type\":\"avg\",\"schema\":\"metric\",\"params\":{\"field\":\"inputKpi.mq2.MQ_2_NSS_UIC_ICE\",\"customLabel\":\"MQ-2-NSS-UIC-ICE\"}},{\"id\":\"9\",\"enabled\":true,\"type\":\"avg\",\"schema\":\"metric\",\"params\":{\"field\":\"inputKpi.mq2.MQ_2_NSS_UIC_PAF_ICE\",\"customLabel\":\"MQ-2-NSS-UIC-PAF-ICE\"}}],\"listeners\":{}}","uiStateJSON": "{}","description": "","version": 1,"kibanaSavedObjectMeta": {"searchSourceJSON": "{\"index\":\"inputkpi\",\"query\":{\"query_string\":{\"query\":\"*\",\"analyze_wildcard\":true}},\"filter\":[]}"}}}]

I believe that bug is fixed in 5.5.1, not 5.5.0. Can you upgrade to 5.5.1 and try importing the visualizations, and seeing if the problem persists?

Thank you! Looks fine now.

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