Eigen Academy

Page tree

Versions Compared

Old Version 8

changes.mady.by.user Murray Callander

Saved on

compared with

New Version Current

changes.mady.by.user Murray Callander

Saved on

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\":\"Just 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\":\"text\",\"value\":\"Using STEPPED()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/TOTALISETOTALISE2(calc/STEPPED(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\}]],[\"refreshrate{\":60,\"canvasColourkind\":\"text\",\"firstrowheadingsvalue\":false,\"hidegridlinesTOTALISE using STEPPED()\":false,\"paddingsize\":\"12\",\"isgridtextSize\":true,\"diagramid12\":false,\"diagramwidthpadding\":1000,\"diagramheight\":,\"title\":null,\"varscolour\":\{\},\"live#333\":1628380799000,\"liveOffsetbgColour\":\"transparent\",\"seamlessoffsetX\":false0,\"tagsoffsetY\":[]0,\"dontPromptOnLiveTogglealignment\":false\}

In BST

Epm macro kpi
config\{\"promptIfDirtyClose\":true"2\",\"kpisweightWidth\":[[\{\"kind1\":,\"datatagweightHeight\",:\"value1\":null,\"sizelayer\":12,\"textSize1\":12,\"paddingmetaData\":\"{\"},\"titledisplay\":null1,\"colourwidth\":\"#333\"100,\"bgColourheight\":\"transparent\"24,\"offsetXdata\":0null,\"offsetYshowIcon\":0false\},\{\"alignmentkind\":2,\"weightWidthdatatag\":1,\"weightHeightvalue\":1,\"layer\":1,\"metaData\"calc/TOTALISE(calc/STEPPED(Demo-influxdb/DEMO_20AP1002.OIW),7d,2021-08-01 00:00:00,1d)\",\"size\":\{"12\}",\"refreshRatetextSize\":10,\"decimalPlaces72\":0,\"unitspadding\":\"\",\"displaytitle\":1,\"status\":1,\"customStatescolour\":\{"#333\}",\"additionalTrendsfgColour\":[],\"additionalTrendTypes#505150\":[],\"additionalTrendMultipliersbgColour\":[],\"additionalTrendMetaDatatransparent\":[],\"showValueoffsetX\":true0,\"useTimestampAsValueoffsetY\":false0,\"minalignment\":0,\"max2\":100,\"innerRadiusRatioweightWidth\":0.6,\"sizeOther1\":null,\"orientationweightHeight\":\"v1\",\"timespanlayer\":\"1\",\"showStatsmetaData\":false,\{\"autoscaleisObjectTemplate\":truenull\},\"numGraduationsrefreshRate\":10110,\"majorGraduationsEverydecimalPlaces\":5,\"sizeDirection0\":null,\"innerAlignmentunits\":null\"Sm³\",\"staleAfterdisplay\":false1,\"showSeparatorstatus\":false1,\"relatedDashboardcustomStates\":false\{\},\{\"kindadditionalTrends\":[],\"datatagadditionalTrendTypes\":[],\"valueadditionalTrendMultipliers\":null[],\"sizeadditionalTrendMetaData\":12[],\"textSizeshowValue\":12true,\"paddinguseTimestampAsValue\":false,\"min\":0,\"titlemax\":null100,\"colourinnerRadiusRatio\":0.6,\"#333sizeOther\":null,\"bgColourorientation\":\"transparentv\",\"offsetXtimespan\":0,\"offsetY\":0,\"alignmentshowStats\":2false,\"weightWidthautoscale\":1true,\"weightHeightnumGraduations\":1101,\"layermajorGraduationsEvery\":15,\"metaDatasizeDirection\":\{\}null,\"refreshRateinnerAlignment\":10null,\"decimalPlacesstaleAfter\":0false,\"unitsshowSeparator\":true,\"relatedDashboard\":false\},\{\"displaykind\":1,\"statustext\":1,\"customStatesvalue\":\{\}"TOTALISE2 using just the tag\",\"additionalTrendssize\":[]\"12\",\"additionalTrendTypestextSize\":[]\"12\",\"additionalTrendMultiplierspadding\":[]\"\",\"additionalTrendMetaDatatitle\":[]null,\"showValuecolour\":true,\"useTimestampAsValue#333\":false,\"minbgColour\":0,\"maxtransparent\":100,\"innerRadiusRatiooffsetX\":0.6,\"sizeOtheroffsetY\":null0,\"orientationalignment\":\"v2\",\"timespanweightWidth\":\"1\",\"showStatsweightHeight\":false,\"autoscale1\":true,\"numGraduationslayer\":101\"1\",\"majorGraduationsEverymetaData\":5\{\},\"sizeDirectiondisplay\":null1,\"innerAlignmentwidth\":null100,\"staleAfterheight\":false24,\"showSeparatordata\":falsenull,\"relatedDashboardshowIcon\":false\}],[\{\"kind\":\"datatag\",\"value\":null,\"size\":12,\"textSize\":12,\"\"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\":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\":5,\"sizeDirection\":null,\"innerAlignment\":null,\"staleAfter\":false,\"showSeparator\":false,\"relatedDashboard\":false\},\{\"kind\":\"datatag\",\"value\":null,\"size\":12,\"textSize\":12,\"padding\":\"\",\"title\":null,\"colour\":\"#333\":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\":true,\"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\":\"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\":\"12\",\"textSize\":\"72\",\"padding\":\"\",\"title\":\"\",\"colour\":\"#333\",\"fgColour\":\"#505150\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":2\"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\":false,\"tags\":[],\"dontPromptOnLiveToggle\":false\}

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

800

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)

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