| 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-0503-25T0227T01:5336:2645\",\"y\":87061\},\{\"x\":\"2024-0704-05T0227T14:4112:0217\",\"y\":535570\},\{\"x\":\"2024-0705-08T2317T00:5510:5015\",\"y\":262\},\{\"x\":\"2024-07-17T0910T02:1748:2439\",\"y\":642119\},\{\"x\":\"2024-07-27T0526T20:3632:2942\",\"y\":657966\},\{\"x\":\"2024-0708-29T0428T09:4359:1339\",\"y\":62675\},\{\"x\":\"2024-09-04T0517T01:5323:5840\",\"y\":5798\},\{\"x\":\"2024-1009-12T0524T19:2303:1144\",\"y\":633989\},\{\"x\":\"2024-10-13T1404T20:5215:2607\",\"y\":139675\},\{\"x\":\"2024-1110-02T0612T23:4942:0341\",\"y\":362529\},\{\"x\":\"2024-1110-03T2217T21:2004:0919\",\"y\":678939\},\{\"x\":\"2024-11-05T0704T04:5009:1543\",\"y\":89663\},\{\"x\":\"2024-11-07T0219T04:2418:2928\",\"y\":959999\},\{\"x\":\"2024-1112-25T2124T01:2909:3948\",\"y\":792951\},\{\"x\":\"2024-12-13T1430T13:1744:3721\",\"y\":282427\},\{\"x\":\"2024-12-27T0631T01:1013:1913\",\"y\":591527\},\{\"x\":\"2025-01-07T2305T03:43:22:14\",\"y\":785\},\{\"x\":\"2025-01-27T00:47:43\",\"y\":755242\},\{\"x\":\"2025-02-10T0520T17:1108:2202\",\"y\":520303\},\{\"x\":\"2025-0302-02T1822T22:4353:3628\",\"y\":334130\}]\},\{\"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, 20) ) SELECT * FROM random_data order by x ~x|$.results.x§y|$.results.y~~false\",\"value\":\"2025-03-11T19:55:24\",\"y\":327\}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 ~x|$.results.x§y|$.results.y~~false\",\"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\",\"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\"\}],\"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\":[]\} |
|---|
|