Eigen Academy

Page tree

Versions Compared

Old Version 8

changes.mady.by.user Murray Callander

Saved on

compared with

New Version 9

changes.mady.by.user Murray Callander

Saved on

Key

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

In the trend below we can see that Totalise resets to 0 on 30th June because it has the interval set to 90d.

Epm macro trendmultichart
config\{\"promptIfDirtyClose\":true,\"layout\":0,\"height\":486,\"width\":0,\"seamless\":false,\"sync\":false,\"charts\":[\{\"trends\":[\{\"type\":\"datatag\",\"name\":\"calc/TOTALISE(1,90d,2021-01-01 00:00:00,1d)\",\"value\":\"calc/TOTALISE(1,90d,2021-01-01 00:00:00,1d)\",\"description\":\"\",\"metaData\":\{\},\"hidden\":false,\"status\":\{\"_params\":\{\"contexts\":\{\}\}\},\"units\":\"\",\"enumerated\":null,\"replacements\":\{\},\"localData\":[]\},\{\"type\":\"datatag\",\"name\":\"calc/TOTALISE2(1,QUARTER,BEGIN_QUARTER,1d,2,1)\",\"value\":\"calc/TOTALISE2(1,QUARTER,BEGIN_QUARTER,1d,2,1)\",\"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\":\"smooth\",\"reference\":null,\"stacked\":false,\"style\":1,\"linestyle\":1,\"lineWidth\":1.5,\"hideFuture\":false,\"groupType\":\"none\",\"groupFunctionType\":\"average\"\}],\"modes\":[\{\"mode\":\"interpolated\"\},\{\"mode\":\"interpolated\"\}],\"bounds\":[1609459200000,1626706800000],\"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,\"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\":[]\}

Set the data in the KPI to 30-Jun-2021 23:59:59.  The TOTALISE function shows 1 because it reset after 29th June because there are actually 91days in the quarter (April + May + June), whereas the TOTALISE2 function gets the number correct at 91.

Epm macro kpi
config\{\"promptIfDirtyClose\":true,\"kpis\":[[\{\"kind\":\"text\",\"value\":\"Totalise\",\"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(1,90d,2021-01-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\":\"days\",\"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\",\"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(1,QUARTER,BEGIN_QUARTER,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\":\"days\",\"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\":\"180d\",\"showStats\":false,\"autoscale\":true,\"numGraduations\":101,\"majorGraduationsEvery\":5,\"sizeDirection\":null,\"innerAlignment\":null,\"staleAfter\":false,\"showSeparator\":true,\"relatedDashboard\":false\}]],\"refreshrate\":60,\"canvasColour\":\"\",\"firstrowheadings\":true,\"hidegridlines\":false,\"padding\":\"\",\"isgrid\":true,\"diagramid\":false,\"diagramwidth\":1000,\"diagramheight\":\"\",\"vars\":\{\},\"live\":1625093999000,\"liveOffset\":\"\",\"seamless\":false,\"tags\":[],\"dontPromptOnLiveToggle\":false\}