Page History

The raw data for our tag should add up to 196 over a week

	Demo-influxdb/DEMO_20AP1002.OIW
2021-08-01 01:00:00 BST	23
2021-08-02 01:00:00 BST	23
2021-08-03 01:00:00 BST	27
2021-08-04 01:00:00 BST	28
2021-08-05 01:00:00 BST	29
2021-08-06 01:00:00 BST	33
2021-08-07 01:00:00 BST	33
TOTAL	196

In GMT

epm-macro-kpi

config

\{\"promptIfDirtyClose\":true,\"kpis\":[[\{\"kind\":\"text\",\"value\":\"TOTALISE using just the Tag\",\"size\":\"12\",\"textSize\":\"12\",\"padding\":\"\",\"title\":null,\"colour\":\"#333\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\},\"display\":1,\"width\":100,\"height\":24,\"data\":null,\"showIcon\":false\},\{\"kind\":\"datatag\",\"value\":\"calc/TOTALISE(Demo-influxdb/DEMO_20AP1002.OIW,7d,2021-08-01 01:00:00,1d)\",\"size\":\"12\",\"textSize\":\"72\",\"padding\":\"\",\"title\":\"\",\"colour\":\"#333\",\"fgColour\":\"#505150\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\},\"refreshRate\":10,\"decimalPlaces\":\"0\",\"units\":\"Sm³\",\"display\":1,\"status\":1,\"customStates\":\{\},\"additionalTrends\":[],\"additionalTrendTypes\":[],\"additionalTrendMultipliers\":[],\"additionalTrendMetaData\":[],\"showValue\":true,\"useTimestampAsValue\":false,\"min\":0,\"max\":100,\"innerRadiusRatio\":0.6,\"sizeOther\":null,\"orientation\":\"v\",\"timespan\":\"\",\"showStats\":false,\"autoscale\":true,\"numGraduations\":101,\"majorGraduationsEvery\":5,\"sizeDirection\":null,\"innerAlignment\":null,\"staleAfter\":false,\"showSeparator\":true,\"relatedDashboard\":false\}],[\{\"kind\":\"text\",\"value\":\"TOTALISE2 using just the tag\",\"size\":\"12\",\"textSize\":\"12\",\"padding\":\"\",\"title\":null,\"colour\":\"#333\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\},\"display\":1,\"width\":100,\"height\":24,\"data\":null,\"showIcon\":false\},\{\"kind\":\"datatag\",\"value\":\"calc/TOTALISE2(Demo-influxdb/DEMO_20AP1002.OIW,7d,2021-08-01 01:00:00,1d,1,1)\",\"size\":\"12\",\"textSize\":\"72\",\"padding\":\"\",\"title\":\"\",\"colour\":\"#333\",\"fgColour\":\"#505150\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\},\"refreshRate\":10,\"decimalPlaces\":\"0\",\"units\":\"Sm³\",\"display\":1,\"status\":1,\"customStates\":\{\},\"additionalTrends\":[],\"additionalTrendTypes\":[],\"additionalTrendMultipliers\":[],\"additionalTrendMetaData\":[],\"showValue\":true,\"useTimestampAsValue\":false,\"min\":0,\"max\":100,\"innerRadiusRatio\":0.6,\"sizeOther\":null,\"orientation\":\"v\",\"timespan\":\"\",\"showStats\":false,\"autoscale\":true,\"numGraduations\":101,\"majorGraduationsEvery\":5,\"sizeDirection\":null,\"innerAlignment\":null,\"staleAfter\":false,\"showSeparator\":true,\"relatedDashboard\":false\}],[\{\"kind\":\"text\",\"value\":\"TOTALISE using STEPPED()\",\"size\":\"12\",\"textSize\":\"12\",\"padding\":\"\",\"title\":null,\"colour\":\"#333\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\},\"display\":1,\"width\":100,\"height\":24,\"data\":null,\"showIcon\":false\},\{\"kind\":\"datatag\",\"value\":\"calc/TOTALISE(calc/STEPPED(Demo-influxdb/DEMO_20AP1002.OIW),7d,2021-08-01 01:00:00,1d)\",\"size\":\"12\",\"textSize\":\"72\",\"padding\":\"\",\"title\":\"\",\"colour\":\"#333\",\"fgColour\":\"#505150\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\},\"refreshRate\":10,\"decimalPlaces\":\"0\",\"units\":\"Sm³\",\"display\":1,\"status\":1,\"customStates\":\{\},\"additionalTrends\":[],\"additionalTrendTypes\":[],\"additionalTrendMultipliers\":[],\"additionalTrendMetaData\":[],\"showValue\":true,\"useTimestampAsValue\":false,\"min\":0,\"max\":100,\"innerRadiusRatio\":0.6,\"sizeOther\":null,\"orientation\":\"v\",\"timespan\":\"\",\"showStats\":false,\"autoscale\":true,\"numGraduations\":101,\"majorGraduationsEvery\":5,\"sizeDirection\":null,\"innerAlignment\":null,\"staleAfter\":false,\"showSeparator\":true,\"relatedDashboard\":false\}]],\"refreshrate\":60,\"canvasColour\":\"\",\"firstrowheadings\":false,\"hidegridlines\":false,\"padding\":\"\",\"isgrid\":true,\"diagramid\":false,\"diagramwidth\":1000,\"diagramheight\":\"\",\"vars\":\{\},\"live\":1628377199000,\"liveOffset\":\"\",\"seamless\":false,\"tags\":[],\"dontPromptOnLiveToggle\":false\}

In BST

Epm macro kpi

config

\{\"promptIfDirtyClose\":true,\"kpis\":[[\{\"kind\":\"text\",\"value\":\"TOTALISE using just the Tag\",\"size\":\"12\",\"textSize\":\"12\",\"padding\":\"\",\"title\":null,\"colour\":\"#333\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\},\"display\":1,\"width\":100,\"height\":24,\"data\":null,\"showIcon\":false\},\{\"kind\":\"datatag\",\"value\":\"calc/TOTALISE(Demo-influxdb/DEMO_20AP1002.OIW,7d,2021-08-01 00:00:00,1d)\",\"size\":\"12\",\"textSize\":\"72\",\"padding\":\"\",\"title\":\"\",\"colour\":\"#333\",\"fgColour\":\"#505150\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\},\"refreshRate\":10,\"decimalPlaces\":\"0\",\"units\":\"Sm³\",\"display\":1,\"status\":1,\"customStates\":\{\},\"additionalTrends\":[],\"additionalTrendTypes\":[],\"additionalTrendMultipliers\":[],\"additionalTrendMetaData\":[],\"showValue\":true,\"useTimestampAsValue\":false,\"min\":0,\"max\":100,\"innerRadiusRatio\":0.6,\"sizeOther\":null,\"orientation\":\"v\",\"timespan\":\"\",\"showStats\":false,\"autoscale\":true,\"numGraduations\":101,\"majorGraduationsEvery\":5,\"sizeDirection\":null,\"innerAlignment\":null,\"staleAfter\":false,\"showSeparator\":true,\"relatedDashboard\":false\},\{\"kind\":\"text\",\"value\":\"TOTALISE using TIMESHIFT\",\"size\":\"12\",\"textSize\":\"12\",\"padding\":\"\",\"title\":null,\"colour\":\"#333\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\},\"display\":1,\"width\":100,\"height\":24,\"data\":null,\"showIcon\":false\},\{\"kind\":\"datatag\",\"value\":\"calc/TOTALISE(calc/TIMESHIFT(Demo-influxdb/DEMO_20AP1002.OIW,1h),7d,2021-08-01 00:00:00,1d)\",\"size\":\"12\",\"textSize\":\"72\",\"padding\":\"\",\"title\":\"\",\"colour\":\"#333\",\"fgColour\":\"#505150\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\},\"refreshRate\":10,\"decimalPlaces\":\"0\",\"units\":\"Sm³\",\"display\":1,\"status\":1,\"customStates\":\{\},\"additionalTrends\":[],\"additionalTrendTypes\":[],\"additionalTrendMultipliers\":[],\"additionalTrendMetaData\":[],\"showValue\":true,\"useTimestampAsValue\":false,\"min\":0,\"max\":100,\"innerRadiusRatio\":0.6,\"sizeOther\":null,\"orientation\":\"v\",\"timespan\":\"\",\"showStats\":false,\"autoscale\":true,\"numGraduations\":101,\"majorGraduationsEvery\":5,\"sizeDirection\":null,\"innerAlignment\":null,\"staleAfter\":false,\"showSeparator\":true,\"relatedDashboard\":false\}],[\{\"kind\":\"text\",\"value\":\"TOTALISE2 using just the tag\",\"size\":\"12\",\"textSize\":\"12\",\"padding\":\"\",\"title\":null,\"colour\":\"#333\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\},\"display\":1,\"width\":100,\"height\":24,\"data\":null,\"showIcon\":false\},\{\"kind\":\"datatag\",\"value\":\"calc/TOTALISE2(Demo-influxdb/DEMO_20AP1002.OIW,7d,2021-08-01 00:00:00,1d,1,1)\",\"size\":\"12\",\"textSize\":\"72\",\"padding\":\"\",\"title\":\"\",\"colour\":\"#333\",\"fgColour\":\"#505150\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\},\"refreshRate\":10,\"decimalPlaces\":\"0\",\"units\":\"Sm³\",\"display\":1,\"status\":1,\"customStates\":\{\},\"additionalTrends\":[],\"additionalTrendTypes\":[],\"additionalTrendMultipliers\":[],\"additionalTrendMetaData\":[],\"showValue\":true,\"useTimestampAsValue\":false,\"min\":0,\"max\":100,\"innerRadiusRatio\":0.6,\"sizeOther\":null,\"orientation\":\"v\",\"timespan\":\"\",\"showStats\":false,\"autoscale\":true,\"numGraduations\":101,\"majorGraduationsEvery\":5,\"sizeDirection\":null,\"innerAlignment\":null,\"staleAfter\":false,\"showSeparator\":true,\"relatedDashboard\":false\},\{\"kind\":\"text\",\"value\":\"TOTALISE2 using TIMESHIFT\",\"size\":\"12\",\"textSize\":\"12\",\"padding\":\"\",\"title\":null,\"colour\":\"#333\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\},\"display\":1,\"width\":100,\"height\":24,\"data\":null,\"showIcon\":false\},\{\"kind\":\"datatag\",\"value\":\"calc/TOTALISE2(calc/TIMESHIFT(Demo-influxdb/DEMO_20AP1002.OIW,1h),7d,2021-08-01 00:00:00,1d,1,1)\",\"size\":\"12\",\"textSize\":\"72\",\"padding\":\"\",\"title\":\"\",\"colour\":\"#333\",\"fgColour\":\"#505150\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\},\"refreshRate\":10,\"decimalPlaces\":\"0\",\"units\":\"Sm³\",\"display\":1,\"status\":1,\"customStates\":\{\},\"additionalTrends\":[],\"additionalTrendTypes\":[],\"additionalTrendMultipliers\":[],\"additionalTrendMetaData\":[],\"showValue\":true,\"useTimestampAsValue\":false,\"min\":0,\"max\":100,\"innerRadiusRatio\":0.6,\"sizeOther\":null,\"orientation\":\"v\",\"timespan\":\"\",\"showStats\":false,\"autoscale\":true,\"numGraduations\":101,\"majorGraduationsEvery\":5,\"sizeDirection\":null,\"innerAlignment\":null,\"staleAfter\":false,\"showSeparator\":true,\"relatedDashboard\":false\}],[\{\"kind\":\"text\",\"value\":\"TOTALISE using STEPPED()\",\"size\":\"12\",\"textSize\":\"12\",\"padding\":\"\",\"title\":null,\"colour\":\"#333\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\},\"display\":1,\"width\":100,\"height\":24,\"data\":null,\"showIcon\":false\},\{\"kind\":\"datatag\",\"value\":\"calc/TOTALISE(calc/STEPPED(Demo-influxdb/DEMO_20AP1002.OIW),7d,2021-08-01 00:00:00,1d)\",\"size\":\"12\",\"textSize\":\"72\",\"padding\":\"\",\"title\":\"\",\"colour\":\"#333\",\"fgColour\":\"#505150\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\},\"refreshRate\":10,\"decimalPlaces\":\"0\",\"units\":\"Sm³\",\"display\":1,\"status\":1,\"customStates\":\{\},\"additionalTrends\":[],\"additionalTrendTypes\":[],\"additionalTrendMultipliers\":[],\"additionalTrendMetaData\":[],\"showValue\":true,\"useTimestampAsValue\":false,\"min\":0,\"max\":100,\"innerRadiusRatio\":0.6,\"sizeOther\":null,\"orientation\":\"v\",\"timespan\":\"\",\"showStats\":false,\"autoscale\":true,\"numGraduations\":101,\"majorGraduationsEvery\":5,\"sizeDirection\":null,\"innerAlignment\":null,\"staleAfter\":false,\"showSeparator\":true,\"relatedDashboard\":false\},\{\"kind\":\"text\",\"value\":\"TOTALISE using STEPPED() & TIMESHIFT\",\"size\":\"12\",\"textSize\":\"12\",\"padding\":\"\",\"title\":null,\"colour\":\"#333\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\},\"display\":1,\"width\":100,\"height\":24,\"data\":null,\"showIcon\":false\},\{\"kind\":\"datatag\",\"value\":\"calc/TOTALISE(calc/TIMESHIFT(calc/STEPPED(Demo-influxdb/DEMO_20AP1002.OIW),1h),7d,2021-08-01 00:00:00,1d)\",\"size\":\"12\",\"textSize\":\"72\",\"padding\":\"\",\"title\":\"\",\"colour\":\"#333\",\"fgColour\":\"#505150\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\},\"refreshRate\":10,\"decimalPlaces\":\"0\",\"units\":\"Sm³\",\"display\":1,\"status\":1,\"customStates\":\{\},\"additionalTrends\":[],\"additionalTrendTypes\":[],\"additionalTrendMultipliers\":[],\"additionalTrendMetaData\":[],\"showValue\":true,\"useTimestampAsValue\":false,\"min\":0,\"max\":100,\"innerRadiusRatio\":0.6,\"sizeOther\":null,\"orientation\":\"v\",\"timespan\":\"\",\"showStats\":false,\"autoscale\":true,\"numGraduations\":101,\"majorGraduationsEvery\":5,\"sizeDirection\":null,\"innerAlignment\":null,\"staleAfter\":false,\"showSeparator\":true,\"relatedDashboard\":false\}]],\"refreshrate\":60,\"canvasColour\":\"\",\"firstrowheadings\":false,\"hidegridlines\":false,\"padding\":\"\",\"isgrid\":true,\"diagramid\":false,\"diagramwidth\":1000,\"diagramheight\":\"\",\"vars\":\{\},\"live\":1628377199000,\"liveOffset\":\"\",\"seamless\":false,\"tags\":[],\"dontPromptOnLiveToggle\":false\}

epm-macro-

trendmultichart

config

\{\"promptIfDirtyClose\":true,\"layout\":0,\"height\":499,\"width\":0,\"seamless\":true,\"sync\":false,\"charts\":[\{\"trends\":[\{\"type\":\"datatag\",\"name\":\"DEMO_20AP1002.OIW\",\"value\":\"Demo-influxdb/DEMO_20AP1002.OIW\",\"description\":\"\",\"metaData\":\{\},\"hidden\":false,\"status\":\{\"_params\":\{\"contexts\":\{\}\}\},\"units\":\"\",\"enumerated\":null,\"replacements\":\{\},\"localData\":[]\}],\"axes\":[\{\"side\":\"left\",\"num\":0,\"min\":\"auto\",\"max\":\"auto\",\"format\":\"auto\",\"step\":\"auto\",\"units\":\"\",\"colour\":\"#ff7f0e\",\"type\":\"step-after\",\"reference\":null,\"stacked\":false,\"style\":1,\"linestyle\":1,\"lineWidth\":1.5,\"hideFuture\":false,\"groupType\":\"none\",\"groupFunctionType\":\"average\"\}],\"modes\":[\{\"mode\":\"raw\"\}],\"bounds\":[1627772400000,1628384400000],\"live\":false,\"liveOffset\":\"\",\"liveSnapTo\":\"\",\"refreshRate\":\"auto\",\"sync\":false,\"title\":\{\"main\":\"\",\"sub\":\"\",\"fgcolour\":\"#333333\",\"bgcolour\":\"#ffffff\",\"size\":\"24\",\"alignment\":\"center\"\},\"seamless\":true,\"locked\":true,\"tz\":\"Europe/London\",\"ampm\":false,\"numPoints\":1000,\"savedPoints\":[],\"type\":\"line\",\"allowExternalChanges\":true,\"scaleToFillHeight\":false,\"noLabelPrefixes\":false,\"hideLegend\":false,\"hideYAxes\":false,\"hideXAxes\":false,\"isTimeBased\":true,\"invertAxes\":false,\"includeStats\":false,\"defaultMargin\":false\}],\"vars\":\{\},\"tags\":[]\}

Epm macro trendmultichart

Page tree

Versions Compared

Old Version 2

New Version 3

Key

In GMT

In BST