Page tree

Versions Compared

Key

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

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 0100: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\":\"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\},\"status{\":1kind\":\"datatag\",\"customStatesvalue\":\{\}"calc/TOTALISE2(Demo-influxdb/DEMO_20AP1002.OIW,7d,2021-08-01 00:00:00,1d)\",\"additionalTrendssize\":[],\"additionalTrendTypes12\":[],\"additionalTrendMultiplierstextSize\":[],\"additionalTrendMetaData72\":[],\"showValuepadding\":true,\"useTimestampAsValue\":false,\"mintitle\":0,\"max\":100,\"innerRadiusRatiocolour\":0.6,\"sizeOther#333\":null,\"orientationfgColour\":\"v#505150\",\"timespanbgColour\":\"transparent\",\"showStatsoffsetX\":false0,\"autoscaleoffsetY\":true0,\"numGraduationsalignment\":101,\"majorGraduationsEvery2\":5,\"sizeDirectionweightWidth\":null,\"innerAlignment1\":null,\"staleAfterweightHeight\":false,\"showSeparator1\":false,\"relatedDashboardlayer\":false\"1\}",\{\"kindmetaData\":\{\"datatagisObjectTemplate\":null\},\"valuerefreshRate\":\"calc/TOTALISE2(Demo-influxdb/DEMO_20AP1002.OIW,7d,2021-08-01 00:00:00,DAY,DEFAULT,DEFAULT)\",\"size\":\"1210,\"decimalPlaces\":\"0\",\"textSizeunits\":\"12Sm³\",\"paddingdisplay\":1,\"status\":1,\"titlecustomStates\":\"{\"},\"colouradditionalTrends\":[],\"#333additionalTrendTypes\":[],\"bgColouradditionalTrendMultipliers\":\"transparent[],\"additionalTrendMetaData\":[],\"offsetXshowValue\":0true,\"offsetYuseTimestampAsValue\":0false,\"alignmentmin\":0,\"2max\":100,\"weightWidthinnerRadiusRatio\":0.6,\"1sizeOther\":null,\"weightHeightorientation\":\"1v\",\"layertimespan\":\"1\",\"metaDatashowStats\":false,\{\"isObjectTemplateautoscale\":null\}true,\"refreshRatenumGraduations\":10101,\"decimalPlacesmajorGraduationsEvery\":5,\"0sizeDirection\":null,\"unitsinnerAlignment\":null,\"staleAfter\":false,\"displayshowSeparator\":1true,\"statusrelatedDashboard\":1false\}],[\{\"customStateskind\":\{\},\"additionalTrendstext\":[],\"additionalTrendTypesvalue\":[],\"additionalTrendMultipliersTOTALISE using STEPPED()\":[],\"additionalTrendMetaDatasize\":[],\"showValue12\":true,\"useTimestampAsValuetextSize\":false,\"min12\":0,\"maxpadding\":100,\"innerRadiusRatio\":0.6,\"sizeOthertitle\":null,\"orientationcolour\":\"v#333\",\"timespanbgColour\":\"transparent\",\"showStatsoffsetX\":false0,\"autoscaleoffsetY\":true0,\"numGraduationsalignment\":101,\"majorGraduationsEvery2\":5,\"sizeDirectionweightWidth\":null,\"innerAlignment1\":null,\"staleAfterweightHeight\":false,\"showSeparator1\":false,\"relatedDashboardlayer\":false\}],[\{\"1\",\"kindmetaData\":\"text{\"},\"valuedisplay\":1,\"Using STEPPED()width\":100,\"sizeheight\":24,\"12data\":null,\"textSizeshowIcon\":false\"12\",},\{\"paddingkind\":\"datatag\",\"title\":nullvalue\":\"calc/TOTALISE(calc/STEPPED(Demo-influxdb/DEMO_20AP1002.OIW),7d,2021-08-01 00:00:00,1d)\",\"coloursize\":\"#33312\",\"bgColourtextSize\":\"transparent72\",\"offsetXpadding\":0,\"offsetY\":0,\"alignmenttitle\":\"2\",\"weightWidthcolour\":\"1#333\",\"weightHeightfgColour\":\"1#505150\",\"layerbgColour\":\"transparent\"1,\"offsetX\":0,\"metaDataoffsetY\":0,\"alignment\":\{"2\}",\"displayweightWidth\":\"1\",\"widthweightHeight\":100\"1\",\"heightlayer\":24\"1\",\"datametaData\":null,\{\"showIconisObjectTemplate\":falsenull\},\{"refreshRate\":10,\"kinddecimalPlaces\":\"datatag0\",\"valueunits\":\"calc/TOTALISE(calc/STEPPED(Demo-influxdb/DEMO_20AP1002.OIW),7d,2021-08-01 01:00:00,1d)Sm³\",\"sizedisplay\":1,\"12status\":1,\"textSizecustomStates\":\"72{\"},\"paddingadditionalTrends\":[],\"additionalTrendTypes\":[],\"titleadditionalTrendMultipliers\":[],\"additionalTrendMetaData\":[],\"colourshowValue\":true,\"#333useTimestampAsValue\":false,\"fgColourmin\":\"#505150\"0,\"bgColourmax\":\"transparent\"100,\"offsetXinnerRadiusRatio\":0.6,\"offsetYsizeOther\":0null,\"alignmentorientation\":\"2v\",\"weightWidthtimespan\":\"1\",\"weightHeightshowStats\":false,\"1autoscale\":true,\"layernumGraduations\":101,\"1majorGraduationsEvery\":5,\"metaDatasizeDirection\":\{\}null,\"refreshRateinnerAlignment\":10null,\"decimalPlacesstaleAfter\":false,\"0showSeparator\":true,\"unitsrelatedDashboard\":false\"Sm³\",},\{\"displaykind\":1,\"statustext\":1,\"customStatesvalue\":\{\},\"additionalTrends\":[]"TOTALISE2 using just the tag\",\"additionalTrendTypessize\":[],\"additionalTrendMultipliers12\":[],\"additionalTrendMetaDatatextSize\":[],\"showValue12\":true,\"useTimestampAsValuepadding\":false,\"min\":0,\"maxtitle\":100null,\"innerRadiusRatiocolour\":0.6,\"sizeOther#333\":null,\"orientationbgColour\":\"vtransparent\",\"timespanoffsetX\":0,\"offsetY\":0,\"showStatsalignment\":false,\"autoscale2\":true,\"numGraduationsweightWidth\":101,\"majorGraduationsEvery1\":5,\"sizeDirectionweightHeight\":null,\"innerAlignment1\":null,\"staleAfterlayer\":false,\"showSeparator1\":true,\"relatedDashboardmetaData\":false\{\}]],\"refreshratedisplay\":601,\"canvasColourwidth\":100,\"height\":24,\"firstrowheadingsdata\":falsenull,\"hidegridlinesshowIcon\":false\},\{\"paddingkind\":\"datatag\",\"isgridvalue\":true,\"diagramid\":false,\"diagramwidth\":1000,\"diagramheight\"calc/TOTALISE2(calc/STEPPED(Demo-influxdb/DEMO_20AP1002.OIW),7d,2021-08-01 00:00:00,1d,1,0)\",\"size\":\"12\",\"textSize\":\"72\",\"varspadding\":\{\},\"live\":1628380799000,\"liveOffsettitle\":\"\",\"seamlesscolour\":false,\"tags#333\":[],\"dontPromptOnLiveTogglefgColour\":false\}

In BST

Epm macro kpi
config\{\"promptIfDirtyClose\":true"#505150\",\"kpisbgColour\":[[\{\"kindtransparent\":,\"datatagoffsetX\":0,\"valueoffsetY\":null0,\"sizealignment\":12,\"textSize2\":12,\"paddingweightWidth\":\"1\",\"titleweightHeight\":null\"1\",\"colourlayer\":\"#3331\",\"bgColourmetaData\":\{\"transparentisObjectTemplate\":null\},\"offsetXrefreshRate\":010,\"offsetYdecimalPlaces\":0,\"alignment\":2,\"weightWidth\":1,\"weightHeight\":1,\"layer\":1,\"metaData\":\{\},\"refreshRate\":10,\"decimalPlaces\":0,\"\"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\":false,\"relatedDashboard\":false\},\{\"kind\":\"datatag\",\"value\":null,\"size\":12,\"textSize\":12,\"padding\":\"\",\"title\":null,\"colour\":\"#333,\"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\"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,\"staleAfter\":false,\"showSeparator\":false,\"relatedDashboard\":false\},\{\"kind\"kind\":\"datatag\",\"value\":\"calc/TOTALISE2(calc/TIMESHIFT(calc/STEPPED(Demo-influxdb/DEMO_20AP1002.OIW),1h),7d,2021-08-01 00:00:00,1d,1,0)\",\"size\":\"datatag12\",\"valuetextSize\":null\"72\",\"sizepadding\":12,\"textSize\":12,\"paddingtitle\":\"\",\"titlecolour\":null\"#333\",\"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\":true1628377199000,\"liveOffset\":\"\",\"seamless\":truefalse,\"tags\":[],\"dontPromptOnLiveToggle\":false\}

Epm macro trendmultichart
config\{\"promptIfDirtyClose\":true,\"layout\":0,\"height\":499,\"width\":0,\"seamless\":

false

true,\"sync\":false,\"charts\":[\{\"trends\":[\{\"type\":\"datatag\",\"name\":\"

DEMO_20AP1002.OIW

Interpolated\",\"value\":\"Demo-influxdb/DEMO_20AP1002.OIW\",\"description\":\"\",\"metaData\":\{\},\"hidden\":false,\"status\":\{\"_params\":\{\"contexts\":\{\}\}\},\"units\":\"\",\"enumerated\":null,\"replacements\":\{\},\"localData\":[]\},\{\"type\":\"datatag\",\"name\":\"

calc/TOTALISE(Demo-influxdb/DEMO_20AP1002.OIW,7d,2021-08-01 00:00:00,1d)

Raw + stepping\",\"value\":\"calc/

TOTALISE

STEPPED(Demo-influxdb/DEMO_20AP1002.OIW

,7d,2021-08-01 00:00:00,1d

)\",\"description\":\"\",\"

colour\":\"#505150\",\"

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

#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\":\"

#505150

#ff7f0e\",\"type\":\"

smooth

step-after\",\"reference\":null,\"stacked\":false,\"style\":1,\"linestyle\":1,\"lineWidth\":1.5,\"hideFuture\":false,\"groupType\":\"none\",\"groupFunctionType\":\"average\"\}],\"modes\":[\{\"mode\":\"

raw

interpolated\"\},\{\"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\":

false

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\":[]\}