| config | \{\"promptIfDirtyClose\":true,\"layout\":0,\"height\":800,\"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-0405-29T1025T02:2253:3926\",\"y\":916870\},\{\"x\":\"2024-0507-21T1205T02:1341:5802\",\"y\":724535\},\{\"x\":\"2024-0307-17T1308T23:1555:0450\",\"y\":4462\},\{\"x\":\"2024-0507-29T1017T09:0817:5324\",\"y\":448642\},\{\"x\":\"2024-0307-27T0827T05:2636:4429\",\"y\":304657\},\{\"x\":\"2024-07-06T0729T04:2643:1113\",\"y\":39262\},\{\"x\":\"2024-1109-27T1904T05:3553:2358\",\"y\":93357\},\{\"x\":\"2024-1110-16T1312T05:5723:2111\",\"y\":948633\},\{\"x\":\"2024-0310-28T0913T14:0552:1126\",\"y\":816139\},\{\"x\":\"2024-0611-16T0902T06:3349:2503\",\"y\":364362\},\{\"x\":\"2024-0411-03T22:2320:4509\",\"y\":931678\},\{\"x\":\"2024-11-21T2305T07:50:5015\",\"y\":663896\},\{\"x\":\"2024-0911-21T2007T02:3524:5029\",\"y\":657959\},\{\"x\":\"20252024-0111-04T1425T21:5529:1139\",\"y\":539792\},\{\"x\":\"20252024-0312-08T1413T14:5317:1737\",\"y\":295282\},\{\"x\":\"2024-0412-16T0627T06:0710:4619\",\"y\":558591\},\{\"x\":\"2025-0201-19T0907T23:4322:3114\",\"y\":97755\},\{\"x\":\"20242025-0802-11T2210T05:11:22:05\",\"y\":550520\},\{\"x\":\"20242025-0803-06T1902T18:0443:3536\",\"y\":137334\},\{\"x\":\"20242025-0503-27T1511T19:4955:3824\",\"y\":750327\}]\}],\"axes\":[\{\"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\":false,\"groupType\":\"none\",\"groupFunctionType\":\"average\",\"maxLabelWidth\":80,\"meta\":\{\"size\":\"default\",\"label\":\"\"\}\}],\"modes\":[\{\"mode\":\"interpolated\"\}],\"bounds\":[1704067200000,1735689600000],\"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]\}\}],\"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\":[]\} |
|---|
|