| config | \{\"promptIfDirtyClose\":true,\"layout\":0,\"height\":540,\"width\":0,\"seamless\":false,\"sync\":false,\"charts\":[\{\"trends\":[\{\"type\":\"datatag\",\"name\":\"sql query\",\"value\":\"datatable//plugins/servlet/epm//eigen-webtools-servlet/sqlquery?&cmd=EXECUTE&db=demo&query=WITH random_data AS ( SELECT TO_CHAR( NOW() - (random() * INTERVAL \'1 year\'), \'YYYY-MM-DD\\\"T\\\"HH24:MI:SS\' ) AS x, floor(random() * 1000) AS y FROM generate_series(1, 20) ) SELECT * FROM random_data order by x\",\"description\":\"\",\"units\":\"\",\"colour\":\"#ff7f0e\",\"metaData\":\{\},\"hidden\":false,\"status\":\{\"_params\":\{\"contexts\":\{\}\}\},\"enumerated\":null,\"replacements\":\{\},\"localData\":[]\},\{\"type\":\"datatag\",\"name\":\"Demo-influxdb/DEMO_12TI111.PV\",\"value\":\"Demo-influxdb/DEMO_12TI111.PV\",\"description\":\"\",\"units\":\"\",\"metaData\":\{\},\"hidden\":false,\"status\":\{\"_params\":\{\"contexts\":\{\}\}\},\"enumerated\":null,\"replacements\":\{\},\"localData\":[]\},\{\"type\":\"datatag\",\"name\":\"datatable//plugins/servlet/epm//eigen-webtools-servlet/sqlquery?&cmd=EXECUTE&db=demo&query=WITH random_data AS ( SELECT TO_CHAR( NOW() - (random() * INTERVAL \'1 year\'), \'YYYY-MM-DD\\\"T\\\"HH24:MI:SS\' ) AS x, floor(random() * 1000) AS y FROM generate_series(1, 25) ) SELECT * FROM random_data order by x\",\"value\":\"datatable//plugins/servlet/epm//eigen-webtools-servlet/sqlquery?&cmd=EXECUTE&db=demo&query=WITH random_data AS ( SELECT TO_CHAR( NOW() - (random() * INTERVAL \'1 year\'), \'YYYY-MM-DD\\\"T\\\"HH24:MI:SS\' ) AS x, floor(random() * 1000) AS y FROM generate_series(1, 25) ) SELECT * FROM random_data order by x\",\"description\":\"\",\"units\":\"\",\"metaData\":\{\},\"hidden\":false,\"status\":\{\"_params\":\{\"contexts\":\{\}\}\},\"enumerated\":null,\"replacements\":\{\},\"localData\":[]\}],\"axes\":[\{\"side\":\"left\",\"num\":0,\"min\":\"auto\",\"max\":\"auto\",\"format\":\"auto\",\"step\":\"auto\",\"units\":\"\",\"colour\":\"#1f77b4\",\"type\":\"smooth\",\"reference\":null,\"stacked\":false,\"style\":1,\"linestyle\":1,\"lineWidth\":1.5,\"hideFuture\":false,\"groupType\":\"none\",\"groupFunctionType\":\"average\",\"maxLabelWidth\":80,\"meta\":\{\"size\":\"default\",\"label\":\"\"\}\},\{\"side\":\"left\",\"num\":0,\"min\":\"auto\",\"max\":\"auto\",\"format\":\"auto\",\"step\":\"auto\",\"units\":\"\",\"colour\":\"#2ca02c\",\"type\":\"smooth\",\"reference\":null,\"stacked\":false,\"style\":1,\"linestyle\":1,\"lineWidth\":1.5,\"hideFuture\":true,\"groupType\":\"none\",\"groupFunctionType\":\"average\",\"maxLabelWidth\":80,\"meta\":\{\}\},\{\"side\":\"left\",\"num\":0,\"min\":\"auto\",\"max\":\"auto\",\"format\":\"auto\",\"step\":\"auto\",\"units\":\"\",\"colour\":\"#2ca02c\",\"type\":\"smooth\",\"reference\":null,\"stacked\":false,\"style\":1,\"linestyle\":1,\"lineWidth\":1.5,\"hideFuture\":true,\"groupType\":\"none\",\"groupFunctionType\":\"average\",\"maxLabelWidth\":80,\"meta\":\{\}\}],\"modes\":[\{\"mode\":\"interpolated\"\},\{\"mode\":\"interpolated\"\},\{\"mode\":\"interpolated\"\}],\"bounds\":[1714604400000,1743462000000],\"boundsHistory\":[\{\"bounds\":[1534160400000,1534246800000],\"minmax\":\{\"0\":[\"auto\",\"auto\"]\}\},\{\"bounds\":[1739352594341,1739438994341],\"minmax\":\{\"0\":[0,\"auto\"]\}\},\{\"bounds\":[1739360075809,1739446475809],\"minmax\":\{\"0\":[0,\"auto\"]\}\},\{\"bounds\":[1739360687129,1739369755054],\"minmax\":\{\"0\":[20,\"21.26\"]\}\},\{\"bounds\":[1739360075809,1739446475809],\"minmax\":\{\"0\":[0,35]\}\},\{\"bounds\":[1704067200000,1735689600000],\"minmax\":\{\"0\":[\"auto\",\"auto\"]\}\},\{\"bounds\":[1704153600000,1735689600000],\"minmax\":\{\"0\":[\"auto\",\"auto\"]\}\},\{\"bounds\":[1704153600000,1743462000000],\"minmax\":\{\"0\":[\"auto\",\"auto\"]\}\}],\"live\":false,\"liveOffset\":\"\",\"liveSnapTo\":\"\",\"refreshRate\":\"auto\",\"sync\":false,\"title\":\{\"main\":\"\",\"sub\":\"\",\"fgcolour\":\"#333333\",\"bgcolour\":\"#ffffff\",\"size\":\"24\",\"alignment\":\"center\"\},\"seamless\":false,\"locked\":true,\"tz\":\"Europe/London\",\"ampm\":false,\"numPoints\":1000,\"useCache\":true,\"savedPoints\":[],\"type\":\"line\",\"allowExternalChanges\":true,\"scaleToFillHeight\":false,\"noLabelPrefixes\":false,\"enableTimeWindowShortcuts\":false,\"timeWindowShortcuts\":null,\"theme\":null,\"hideLegend\":false,\"hideYAxes\":false,\"hideXAxes\":false,\"isTimeBased\":true,\"invertAxes\":false,\"includeStats\":false,\"defaultMargin\":false,\"duration\":\"\"\}],\"vars\":\{\},\"tags\":[]\} |
|---|
|