Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Epm macro trendmultichart
config\{\"promptIfDirtyClose\":true,\"layout\":0,\"height\":800540,\"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\":[]\},\{\"xtype\":\"2024-05-25T02:53:26datatag\",\"yname\":870\},\{\"x\"Demo-influxdb/DEMO_12TI111.PV\",\"value\":\"2024-07-05T02:41:02Demo-influxdb/DEMO_12TI111.PV\",\"ydescription\":535\"\}",\{\"xunits\":\"2024-07-08T23:55:50\",\"ymetaData\":2\{\},\"hidden\":false,\"status\":\{\"x_params\":\"2024-07-17T09:17:24\",\"y\":642{\"contexts\":\{\}\}\},\"enumerated\":null,\"replacements\":\{\},\"localData\":[]\},\{\"xtype\":\"datatag\",\"name\":\"2024-07-27T05:36:29\",\"y\":657\},\{\"x\":\"2024-07-29T04:43:13\",\"y\":62\},\{\"x\":\"2024-09-04T05:53:58\",\"y\":57\},\{\"x\":\"2024-10-12T05:23:11\",\"y\":633\},\{\"x\":\"2024-10-13T14:52:26\",\"y\":139\},\{\"x\":\"2024-11-02T06:49:03\",\"y\":362\},\{\"x\":\"2024-11-03T22:20:09\",\"y\":678\},\{\"x\":\"2024-11-05T07:50:15\",\"y\":896\},\{\"x\":\"2024-11-07T02:24:29\",\"y\":959\},\{\"x\":\"2024-11-25T21:29:39\",\"y\":792\},\{\"x\":\"2024-12-13T14:17:37\",\"y\":282\},\{\"x\":\"2024-12-27T06:10:19\",\"y\":591\},\{\"x\":\"2025-01-07T23:22:14\",\"y\":755\},\{\"x\":\"2025-02-10T05:11:22\",\"y\":520\},\{\"x\":\"2025-03-02T18:43:36\",\"y\":334\},\{\"x\":\"2025-03-11T19:55:24\",\"y\":327\}]\}],\"axes\":[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\":\"#ff7f0e#2ca02c\",\"type\":\"smooth\",\"reference\":null,\"stacked\":false,\"style\":1,\"linestyle\":1,\"lineWidth\":1.5,\"hideFuture\":falsetrue,\"groupType\":\"none\",\"groupFunctionType\":\"average\",\"maxLabelWidth\":80,\"meta\":\{\}\}],\"sizemodes\":[\"default{\",\"labelmode\":\"interpolated\"\},\}],{\"modesmode\":[\"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\":[]\}