Visualization not showing lines correctly

dulman · October 10, 2017, 1:14pm

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!

dulman · October 10, 2017, 1:19pm

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\":[]}"}}}]

dulman · October 10, 2017, 1:20pm

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\":[]}"}}}]

Stacey_Gammon · October 10, 2017, 3:08pm

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?

dulman · October 12, 2017, 8:47am

Thank you! Looks fine now.

system · November 9, 2017, 8:47am

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