| 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\":[\{\"x\":\"2024-03-27T01:36:45\",\"y\":61\]\},\{\"xtype\":\"2024-04-27T14:12:17datatag\",\"y\":570\},\{name\"x\":\"2024-05-17T00:10:15Demo-influxdb/DEMO_12TI111.PV\",\"y\":62\},\{\"x\value\":\"2024-07-10T02:48:39Demo-influxdb/DEMO_12TI111.PV\",\"ydescription\":119\},\{\"x\":\"2024-07-26T20:32:42\",\"y\":966\},\{\"xunits\":\"2024-08-28T09:59:39\",\"ymetaData\":675\},\{\"x\":\"2024-09-17T01:23:40\",\"y\":98\},\{\"xhidden\":\"2024-09-24T19:03:44\"false,\"ystatus\":989\},\{\"x\":\"2024-10-04T20:15:07\",\"y_params\":675\},\{\"x\":\"2024-10-12T23:42:41\",\"ycontexts\":529\},\{\"x\":\"2024-10-17T21:04:19\",\"y\":939\},\{\"x\":\"2024-11-04T04:09:43\",\"y\":63\},\{\"x\":\"2024-11-19T04:18:28\",\"y\":999\},\{\"xenumerated\":\"2024-12-24T01:09:48\"null,\"yreplacements\":951\},\{\"x\":\"2024-12-30T13:44:21\",\"y\":427\},\{\"x\":\"2024-12-31T01:13:13\",\"y\":527\},\{\"x\":\"2025-01-05T03:43:22\",\"y\":785\},\{\"x\":\"2025-01-27T00:47:43\",\"y\":242\},\{\"x\":\"2025-02-20T17:08:02\",\"y\":303\},\{\"x\":\"2025-02-22T22:53:28\",\"y\":130\}localData\":[]\},\{\"type\":\"datatag\",\"name\":\"datatable//plugins/servlet/epm//eigen-webtools-servlet/sqlquery~cmd|EXECUTE§db|demo§query|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, 2025) ) SELECT * FROM random_data order by x ~x|$.results.x§y|$.results.y~~false\",\"value\":\"datatable//plugins/servlet/epm//eigen-webtools-servlet/sqlquery~cmd|EXECUTE§db|demo§query|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, 2025) ) SELECT * FROM random_data order by x ~x|$.results.x§y|$.results.y~~false\",\"description\":\"\",\"units\":\"\",\"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\":[]\}],\"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\":\"#ff7f0e#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\":[]\} |
|---|
|