| config | \{\"promptIfDirtyClose\":true,\"layout\":1,\"height\":878,\"width\":0,\"seamless\":false,\"sync\":false,\"charts\":[\{\"trends\":[\{\"type\":\"datatag\",\"name\":\"totalise mtd\",\"value\":\"calc/MAX(MUL(TOTALISE(MUL(STEPPED(Demo-influxdb/DEMO_ODDMONTHS),TIMESHIFT(Demo-influxdb/DEMO_20FQ1001.OLDAV,1d),TIMESHIFT(Demo-influxdb/DEMO_20AP1002.OIW,-1d)),60d,2017-12-15 00:00:00,1d),STEPPED(Demo-influxdb/DEMO_ODDMONTHS)),MUL(TOTALISE(MUL(STEPPED(Demo-influxdb/DEMO_EVENMONTHS),TIMESHIFT(Demo-influxdb/DEMO_20FQ1001.OLDAV,1d),TIMESHIFT(Demo-influxdb/DEMO_20AP1002.OIW,-1d)),61d,2018-01-15 00:00:00,1d),STEPPED(Demo-influxdb/DEMO_EVENMONTHS)))\",\"description\":\"\",\"metaData\":\{\},\"hidden\":false,\"status\":\{\"_params\":\{\"contexts\":\{\}\}\},\"units\":\"\",\"enumerated\":null,\"replacements\":\{\},\"localData\":[]\},\{\"type\":\"datatag\",\"name\":\"calc/THRESHOLD(TOTALISE(ADD(1),365d,2018-01-01 00:00:00,1d),3,THRESHOLD(TOTALISE(ADD(1),365d,2018-02-01 00:00:00,1d),28,THRESHOLD(TOTALISE(ADD(1),365d,2018-03-01 00:00:00,1d),31,THRESHOLD(TOTALISE(ADD(1),365d,2018-04-01 00:00:00,1d),30,THRESHOLD(TOTALISE(ADD(1),365d,2018-05-01 00:00:00,1d),31,THRESHOLD(TOTALISE(ADD(1),365d,2018-06-01 00:00:00,1d),30,THRESHOLD(TOTALISE(ADD(1),365d,2018-08-01 00:00:00,1d),31,THRESHOLD(TOTALISE(ADD(1),365d,2018-09-01 00:00:00,1d),30,THRESHOLD(TOTALISE(ADD(1),365d,2018-10-01 00:00:00,1d),31,THRESHOLD(TOTALISE(ADD(1),365d,2018-11-01 00:00:00,1d),30,THRESHOLD(TOTALISE(ADD(1),365d,2018-12-01 00:00:00,1d),31,0,TOTALISE(ADD(1),365d,2018-12-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-11-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-10-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-09-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-08-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-06-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-05-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-04-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-03-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-02-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-01-01 00:00:00,1d))\",\"value\":\"calc/THRESHOLD(TOTALISE(ADD(1),365d,2018-01-01 00:00:00,1d),31,THRESHOLD(TOTALISE(ADD(1),365d,2018-02-01 00:00:00,1d),28,THRESHOLD(TOTALISE(ADD(1),365d,2018-03-01 00:00:00,1d),31,THRESHOLD(TOTALISE(ADD(1),365d,2018-04-01 00:00:00,1d),30,THRESHOLD(TOTALISE(ADD(1),365d,2018-05-01 00:00:00,1d),31,THRESHOLD(TOTALISE(ADD(1),365d,2018-06-01 00:00:00,1d),30,THRESHOLD(TOTALISE(ADD(1),365d,2018-08-01 00:00:00,1d),31,THRESHOLD(TOTALISE(ADD(1),365d,2018-09-01 00:00:00,1d),30,THRESHOLD(TOTALISE(ADD(1),365d,2018-10-01 00:00:00,1d),31,THRESHOLD(TOTALISE(ADD(1),365d,2018-11-01 00:00:00,1d),30,THRESHOLD(TOTALISE(ADD(1),365d,2018-12-01 00:00:00,1d),31,0,TOTALISE(ADD(1),365d,2018-12-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-11-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-10-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-09-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-08-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-06-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-05-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-04-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-03-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-02-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-01-01 00:00:00,1d))\",\"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\},\{\"side\":\"right\",\"num\":0,\"min\":\"0\",\"max\":\"3540\",\"format\":\"auto\",\"step\":\"auto\",\"units\":\"\",\"colour\":\"#ff7f0e\",\"type\":\"smooth\",\"reference\":null,\"stacked\":false,\"style\":1,\"linestyle\":1,\"lineWidth\":1.5,\"hideFuture\":false\}],\"modes\":[\{\"mode\":\"interpolated\"\},\{\"mode\":\"interpolated\"\}],\"bounds\":[1514764800000,1546300800000],\"live\":false,\"liveOffset\":\"\",\"liveSnapTo\":\"\",\"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\":true,\"defaultMargin\":false\},\{\"trends\":[\{\"type\":\"datatag\",\"name\":\"calc/DIV(calc/MAX(MUL(TOTALISE(MUL(STEPPED(Demo-influxdb/DEMO_ODDMONTHS),TIMESHIFT(Demo-influxdb/DEMO_20FQ1001.OLDAV,1d),TIMESHIFT(Demo-influxdb/DEMO_20AP1002.OIW,-1d)),60d,2017-12-15 00:00:00,1d),STEPPED(Demo-influxdb/DEMO_ODDMONTHS)),MUL(TOTALISE(MUL(STEPPED(Demo-influxdb/DEMO_EVENMONTHS),TIMESHIFT(Demo-influxdb/DEMO_20FQ1001.OLDAV,1d),TIMESHIFT(Demo-influxdb/DEMO_20AP1002.OIW,-1d)),61d,2018-01-15 00:00:00,1d),STEPPED(Demo-influxdb/DEMO_EVENMONTHS))),calc/THRESHOLD(TOTALISE(ADD(1),365d,2018-01-01 00:00:00,1d),31,THRESHOLD(TOTALISE(ADD(1),365d,2018-02-01 00:00:00,1d),28,THRESHOLD(TOTALISE(ADD(1),365d,2018-03-01 00:00:00,1d),31,THRESHOLD(TOTALISE(ADD(1),365d,2018-04-01 00:00:00,1d),30,THRESHOLD(TOTALISE(ADD(1),365d,2018-05-01 00:00:00,1d),31,THRESHOLD(TOTALISE(ADD(1),365d,2018-06-01 00:00:00,1d),30,THRESHOLD(TOTALISE(ADD(1),365d,2018-08-01 00:00:00,1d),31,THRESHOLD(TOTALISE(ADD(1),365d,2018-09-01 00:00:00,1d),30,THRESHOLD(TOTALISE(ADD(1),365d,2018-10-01 00:00:00,1d),31,THRESHOLD(TOTALISE(ADD(1),365d,2018-11-01 00:00:00,1d),30,THRESHOLD(TOTALISE(ADD(1),365d,2018-12-01 00:00:00,1d),31,0,TOTALISE(ADD(1),365d,2018-12-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-11-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-10-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-09-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-08-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-06-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-05-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-04-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-03-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-02-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-01-01 00:00:00,1d)))\",\"value\":\"calc/DIV(calc/MAX(MUL(TOTALISE(MUL(STEPPED(Demo-influxdb/DEMO_ODDMONTHS),TIMESHIFT(Demo-influxdb/DEMO_20FQ1001.OLDAV,1d),TIMESHIFT(Demo-influxdb/DEMO_20AP1002.OIW,-1d)),60d,2017-12-15 00:00:00,1d),STEPPED(Demo-influxdb/DEMO_ODDMONTHS)),MUL(TOTALISE(MUL(STEPPED(Demo-influxdb/DEMO_EVENMONTHS),TIMESHIFT(Demo-influxdb/DEMO_20FQ1001.OLDAV,1d),TIMESHIFT(Demo-influxdb/DEMO_20AP1002.OIW,-1d)),61d,2018-01-15 00:00:00,1d),STEPPED(Demo-influxdb/DEMO_EVENMONTHS))),calc/THRESHOLD(TOTALISE(ADD(1),365d,2018-01-01 00:00:00,1d),31,THRESHOLD(TOTALISE(ADD(1),365d,2018-02-01 00:00:00,1d),28,THRESHOLD(TOTALISE(ADD(1),365d,2018-03-01 00:00:00,1d),31,THRESHOLD(TOTALISE(ADD(1),365d,2018-04-01 00:00:00,1d),30,THRESHOLD(TOTALISE(ADD(1),365d,2018-05-01 00:00:00,1d),31,THRESHOLD(TOTALISE(ADD(1),365d,2018-06-01 00:00:00,1d),30,THRESHOLD(TOTALISE(ADD(1),365d,2018-08-01 00:00:00,1d),31,THRESHOLD(TOTALISE(ADD(1),365d,2018-09-01 00:00:00,1d),30,THRESHOLD(TOTALISE(ADD(1),365d,2018-10-01 00:00:00,1d),31,THRESHOLD(TOTALISE(ADD(1),365d,2018-11-01 00:00:00,1d),30,THRESHOLD(TOTALISE(ADD(1),365d,2018-12-01 00:00:00,1d),31,0,TOTALISE(ADD(1),365d,2018-12-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-11-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-10-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-09-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-08-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-06-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-05-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-04-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-03-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-02-01 00:00:00,1d)),TOTALISE(ADD(1),365d,2018-01-01 00:00:00,1d)))\",\"description\":\"\",\"metaData\":\{\},\"hidden\":false,\"status\":\{\"_params\":\{\"contexts\":\{\}\}\},\"units\":\"\",\"enumerated\":null,\"replacements\":\{\},\"localData\":[]\},\{\"type\":\"datatag\",\"name\":\"calc/MUL(calc/TIMESHIFT(Demo-influxdb/DEMO_20FQ1001.OLDAV,1d),calc/TIMESHIFT(Demo-influxdb/DEMO_20AP1002.OIW,-1d))\",\"value\":\"calc/MUL(calc/TIMESHIFT(Demo-influxdb/DEMO_20FQ1001.OLDAV,1d),calc/TIMESHIFT(Demo-influxdb/DEMO_20AP1002.OIW,-1d))\",\"description\":\"\",\"metaData\":\{\},\"hidden\":false,\"status\":\{\"_params\":\{\"contexts\":\{\}\}\},\"units\":\"\",\"enumerated\":null,\"replacements\":\{\},\"localData\":[]\}],\"axes\":[\{\"side\":\"left\",\"num\":0,\"min\":\"0\",\"max\":\"14000\",\"format\":\"auto\",\"step\":\"auto\",\"units\":\"\",\"colour\":\"#1f77b4\",\"type\":\"smooth\",\"reference\":null,\"stacked\":true,\"style\":1,\"linestyle\":1,\"lineWidth\":1.5,\"hideFuture\":false\},\{\"side\":\"left\",\"num\":2,\"min\":\"0\",\"max\":\"14000\",\"format\":\"auto\",\"step\":\"auto\",\"units\":\"\",\"colour\":\"#ff7f0e\",\"type\":\"smooth\",\"reference\":null,\"stacked\":false,\"style\":1,\"linestyle\":1,\"lineWidth\":1.5,\"hideFuture\":false\}],\"modes\":[\{\"mode\":\"interpolated\"\},\{\"mode\":\"interpolated\"\}],\"bounds\":[1514764800000,1544842800000],\"live\":false,\"liveOffset\":\"\",\"liveSnapTo\":\"\",\"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\":[]\} |
|---|
|