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

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\":\{\"isObjectTemplate\":null\},\"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\":\":nullcalc/TOTALISE2(Demo-influxdb/DEMO_20AP1002.OIW,7d,2021-08-01 00:00:00,1d)\",\"size\":\"12\",\"textSize\":12\"72\",\"padding\":\"\",\"title\":null\"\",\"colour\":\"#333\",\"fgColour\":\"#505150\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\"isObjectTemplate\":null\},\"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\":falsetrue,\"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\":null,\"size\":12,\"textSize\":12\"calc/TOTALISE(calc/STEPPED(Demo-influxdb/DEMO_20AP1002.OIW),7d,2021-08-01 00:00:00,1d)\",\"size\":\"12\",\"textSize\":\"72\",\"padding\":\"\",\"title\":null\"\",\"colour\":\"#333\",\"fgColour\":\"#505150\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1,\",\"layer\":\"1\",\"metaData\":\{\"isObjectTemplate\":null\},\"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\":falsetrue,\"relatedDashboard\":false\},\{\"kind\":\"datatagtext\",\"value\":null\"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\":\{\},\"refreshRatedisplay\":101,\"decimalPlaceswidth\":0100,\"unitsheight\":24,\"data\":null,\"displayshowIcon\":1false\},\{\"statuskind\":1,\"customStatesdatatag\":\{\},\"additionalTrendsvalue\":[],\"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\":false,\"relatedDashboard\":false\},\{\"kind\":\"datatag\",\"value\":null,\"size\":12,\"textSize\":12,\"padding\":\"\",\"title\":null,\"colour\":\"#333\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":2,\"weightWidth\":1,\"weightHeight\":1,\"layer\":1,\"metaData\":\{\},\"refreshRate\":10,\"decimalPlaces\":0,\"units\":\"\",\"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\":false,\"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\":null,\"size\":12,\"textSize\":12,\"padding\":\"\",\"title\":null,\"colour\":\"#333\"calc/TOTALISE2(calc/STEPPED(Demo-influxdb/DEMO_20AP1002.OIW),7d,2021-08-01 00:00:00,1d,1,0)\",\"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\":\{\"isObjectTemplate\":null\},\"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\":\{\"isObjectTemplate\":null\},\"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\":falsetrue,\"relatedDashboard\":false\},\{\"kind\":\"datatag\",\"value\":null,\"size\":12,\"textSize\":12,\"padding\":\"\",\"title\":null,\"colour\":\"#333\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":2,\"weightWidth\":1,\"weightHeight\":1,\"layer\":1,\"metaData\":\{\},\"refreshRate\":10,\"decimalPlaces\":0,\"units\":\"\",\"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,\"showStatsstaleAfter\":false,\"autoscaleshowSeparator\":truefalse,\"numGraduationsrelatedDashboard\":101false\},\{\"majorGraduationsEverykind\":5,\"sizeDirectiondatatag\":null,\"innerAlignmentvalue\":null,\"staleAfter\":false,\"showSeparator\":false,\"relatedDashboard\":false\},\{\"kind\"calc/TOTALISE2(calc/TIMESHIFT(calc/STEPPED(Demo-influxdb/DEMO_20AP1002.OIW),1h),7d,2021-08-01 00:00:00,1d,1,0)\",\"size\":\"12\",\"textSize\":\"datatag72\",\"valuepadding\":null,\"size\":12,\"textSizetitle\":12,\"padding\":,\"colour\",:\"title#333\":null,\"colourfgColour\":\"#333#505150\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\"isObjectTemplate\":null\},\"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\":falsetrue,\"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\":\"Interpolated\",\"value\":\"Demo-influxdb/DEMO_20AP1002.OIW\",\"description\":\"\",\"metaData\":\{\},\"hidden\":false,\"status\":\{\"_params\":\{\"contexts\":\{\}\}\},\"units\":\"\",\"enumerated\":null,\"replacements\":\{\},\"localData\":[]\},\{\"type\":\"datatag\",\"name\":\"Raw + stepping\",\"value\":\"calc/STEPPED(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\":\"#1f77b4\",\"type\":\"smooth\",\"reference\":null,\"stacked\":false,\"style\":1,\"linestyle\":1,\"lineWidth\":1.5,\"hideFuture\":false,\"groupType\":\"none\",\"groupFunctionType\":\"average\"\},\{\"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\":\"rawinterpolated\"\},\{\"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\":[]\}

...

Page tree

Versions Compared

Old Version 23

New Version Current

Key