Page tree

Versions Compared

Key

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

epm-macro-editor
config\{\"seamless\":true,\"editor\":\{\"html\":\"%3Cdiv%20style%3D%5C%22color%3A%20black%3B%20height%3A%2040px%3B%20align-items%3A%20center%3B%20display%3A%20flex%3B%20justify-content%3A%20center%3B%20border-bottom%3A%200.5px%20solid%20black%3B%20font-weight%3A%20bold%3B%20font-size%3A%2020px%3B%20page-break-before%3A%20always%3B%5C%22%3EYearly%20Figures%3C%2Fdiv%3E\"\},\"tags\":[\"dpr\"],\"promptIfDirtyClose\":true\}

Epm macro editor
config\{\"seamless\":true,\"editor\":\{\"html\":\"%3Ctable%20style%3D%5C%22width%3A%20100o-o%3B%20border-collapse%3A%20collapse%3B%20border-style%3A%20hidden%3B%20background-color%3A%20%2384c561%3B%20height%3A%2036px%3B%5C%22%20border%3D%5C%221%5C%22%3E%0A%3Ctbody%3E%0A%3Ctr%20style%3D%5C%22text-align%3A%20left%3B%5C%22%3E%0A%3Ctd%20style%3D%5C%22width%3A%20100o-o%3B%20height%3A%2036px%3B%20background-color%3A%20%2384c561%3B%20text-align%3A%20left%3B%20vertical-align%3A%20middle%3B%5C%22%20scope%3D%5C%22row%5C%22%3E%3Cspan%20style%3D%5C%22color%3A%20%23ffffff%3B%5C%22%3E%3Cstrong%3E%26nbsp%3B%20%3Cspan%20style%3D%5C%22color%3A%20%231d1d1d%3B%5C%22%3EBalder%2FRinghorne%20gross%20oil%20production%3C%2Fspan%3E%3C%2Fstrong%3E%3C%2Fspan%3E%3C%2Ftd%3E%0A%3C%2Ftr%3E%0A%3C%2Ftbody%3E%0A%3C%2Ftable%3E\"\},\"tags\":[\"dpr\"],\"promptIfDirtyClose\":true\}

epm-macro-trendmultichart
config\{\"layout\":0,\"height\":482,\"width\":0,\"seamless\":true,\"sync\":false,\"charts\":[\{\"trends\":[\{\"type\":\"datatag\",\"name\":\"AP\",\"value\":\"local/datatable//plugins/servlet/epm//eigen-webtools-servlet/sqlquery?&cmd=EXECUTE&db=ecnor-db&query= with P as (select DAYTIME as DAYTIME, SUM(NET_VOL) as AP from dv_strm_day_pc_alloc where DAYTIME between (select TRUNC (sysdate,\'YEAR\') from DUAL) and (select TRUNC (CURRENT_DATE) from DUAL) and OBJECT_CODE = \'BAL1001\' and PROFIT_CENTRE_CODE in (\'BALDER_FIELD\', \'RHE_FIELD\', \'RH_FIELD\') group by DAYTIME ), Q as ( SELECT ((select TRUNC (sysdate,\'YEAR\') from DUAL) %2B (LEVEL - 1)) AS DAYTIME, (select 0 from dual) as ZERO FROM DUAL connect by level <=( sysdate-((select TRUNC (sysdate,\'YEAR\') from DUAL))) ) SELECT concat(to_char(Q.DAYTIME,\'YYYY-MM-DD\'),\'T00:00:00\') as %22x%22, round(coalesce(P.AP,0),0) as %22y%22 FROM Q LEFT JOIN P ON Q.DAYTIME = P.DAYTIME order by Q.DAYTIME\",\"description\":\"\",\"metaData\":\{\},\"hidden\":false,\"status\":\{\"_params\":\{\"contexts\":\{\}\}\},\"units\":\"sm3\",\"enumerated\":null,\"replacements\":\{\"reporttime\":\"1673305199000\"\},\"localData\":[\{\"x\":\"2023-01-01T00:00:00\",\"y\":2608\},\{\"x\":\"2023-01-02T00:00:00\",\"y\":2704\},\{\"x\":\"2023-01-03T00:00:00\",\"y\":2980\},\{\"x\":\"2023-01-04T00:00:00\",\"y\":3091\},\{\"x\":\"2023-01-05T00:00:00\",\"y\":3608\},\{\"x\":\"2023-01-06T00:00:00\",\"y\":3611\},\{\"x\":\"2023-01-07T00:00:00\",\"y\":3030\},\{\"x\":\"2023-01-08T00:00:00\",\"y\":1890\},\{\"x\":\"2023-01-09T00:00:00\",\"y\":2071\},\{\"x\":\"2023-01-10T00:00:00\",\"y\":3270\},\{\"x\":\"2023-01-11T00:00:00\",\"y\":3458\},\{\"x\":\"2023-01-12T00:00:00\",\"y\":3449\},\{\"x\":\"2023-01-13T00:00:00\",\"y\":3461\},\{\"x\":\"2023-01-14T00:00:00\",\"y\":3461\},\{\"x\":\"2023-01-15T00:00:00\",\"y\":3474\},\{\"x\":\"2023-01-16T00:00:00\",\"y\":3570\},\{\"x\":\"2023-01-17T00:00:00\",\"y\":3627\},\{\"x\":\"2023-01-18T00:00:00\",\"y\":3659\},\{\"x\":\"2023-01-19T00:00:00\",\"y\":3604\},\{\"x\":\"2023-01-20T00:00:00\",\"y\":3558\},\{\"x\":\"2023-01-21T00:00:00\",\"y\":3627\},\{\"x\":\"2023-01-22T00:00:00\",\"y\":3688\},\{\"x\":\"2023-01-23T00:00:00\",\"y\":3418\},\{\"x\":\"2023-01-24T00:00:00\",\"y\":3513\},\{\"x\":\"2023-01-25T00:00:00\",\"y\":3486\},\{\"x\":\"2023-01-26T00:00:00\",\"y\":3455\},\{\"x\":\"2023-01-27T00:00:00\",\"y\":1799\},\{\"x\":\"2023-01-28T00:00:00\",\"y\":1925\},\{\"x\":\"2023-01-29T00:00:00\",\"y\":3182\},\{\"x\":\"2023-01-30T00:00:00\",\"y\":3190\},\{\"x\":\"2023-01-31T00:00:00\",\"y\":3226\},\{\"x\":\"2023-02-01T00:00:00\",\"y\":3284\},\{\"x\":\"2023-02-02T00:00:00\",\"y\":3318\},\{\"x\":\"2023-02-03T00:00:00\",\"y\":3434\},\{\"x\":\"2023-02-04T00:00:00\",\"y\":3375\},\{\"x\":\"2023-02-05T00:00:00\",\"y\":3372\},\{\"x\":\"2023-02-06T00:00:00\",\"y\":3561\},\{\"x\":\"2023-02-07T00:00:00\",\"y\":3538\},\{\"x\":\"2023-02-08T00:00:00\",\"y\":3555\},\{\"x\":\"2023-02-09T00:00:00\",\"y\":2979\},\{\"x\":\"2023-02-10T00:00:00\",\"y\":2593\},\{\"x\":\"2023-02-11T00:00:00\",\"y\":2662\},\{\"x\":\"2023-02-12T00:00:00\",\"y\":2750\},\{\"x\":\"2023-02-13T00:00:00\",\"y\":2798\},\{\"x\":\"2023-02-14T00:00:00\",\"y\":2709\},\{\"x\":\"2023-02-15T00:00:00\",\"y\":2698\},\{\"x\":\"2023-02-16T00:00:00\",\"y\":2669\},\{\"x\":\"2023-02-17T00:00:00\",\"y\":2562\},\{\"x\":\"2023-02-18T00:00:00\",\"y\":2528\},\{\"x\":\"2023-02-19T00:00:00\",\"y\":2467\},\{\"x\":\"2023-02-20T00:00:00\",\"y\":2436\},\{\"x\":\"2023-02-21T00:00:00\",\"y\":2528\},\{\"x\":\"2023-02-22T00:00:00\",\"y\":2515\},\{\"x\":\"2023-02-23T00:00:00\",\"y\":2504\},\{\"x\":\"2023-02-24T00:00:00\",\"y\":2522\},\{\"x\":\"2023-02-25T00:00:00\",\"y\":2539\},\{\"x\":\"2023-02-26T00:00:00\",\"y\":2503\},\{\"x\":\"2023-02-27T00:00:00\",\"y\":2465\},\{\"x\":\"2023-02-28T00:00:00\",\"y\":2513\},\{\"x\":\"2023-03-01T00:00:00\",\"y\":2774\},\{\"x\":\"2023-03-02T00:00:00\",\"y\":2258\},\{\"x\":\"2023-03-03T00:00:00\",\"y\":2189\},\{\"x\":\"2023-03-04T00:00:00\",\"y\":2420\},\{\"x\":\"2023-03-05T00:00:00\",\"y\":2450\},\{\"x\":\"2023-03-06T00:00:00\",\"y\":2605\},\{\"x\":\"2023-03-07T00:00:00\",\"y\":2639\},\{\"x\":\"2023-03-08T00:00:00\",\"y\":2577\},\{\"x\":\"2023-03-09T00:00:00\",\"y\":2624\},\{\"x\":\"2023-03-10T00:00:00\",\"y\":2649\},\{\"x\":\"2023-03-11T00:00:00\",\"y\":2581\},\{\"x\":\"2023-03-12T00:00:00\",\"y\":2582\},\{\"x\":\"2023-03-13T00:00:00\",\"y\":2575\},\{\"x\":\"2023-03-14T00:00:00\",\"y\":2539\},\{\"x\":\"2023-03-15T00:00:00\",\"y\":2242\},\{\"x\":\"2023-03-16T00:00:00\",\"y\":2335\},\{\"x\":\"2023-03-17T00:00:00\",\"y\":2520\},\{\"x\":\"2023-03-18T00:00:00\",\"y\":2427\},\{\"x\":\"2023-03-19T00:00:00\",\"y\":2459\},\{\"x\":\"2023-03-20T00:00:00\",\"y\":2494\},\{\"x\":\"2023-03-21T00:00:00\",\"y\":2443\},\{\"x\":\"2023-03-22T00:00:00\",\"y\":2369\},\{\"x\":\"2023-03-23T00:00:00\",\"y\":2338\},\{\"x\":\"2023-03-24T00:00:00\",\"y\":2326\},\{\"x\":\"2023-03-25T00:00:00\",\"y\":2286\},\{\"x\":\"2023-03-26T00:00:00\",\"y\":2214\},\{\"x\":\"2023-03-27T00:00:00\",\"y\":2288\},\{\"x\":\"2023-03-28T00:00:00\",\"y\":2257\},\{\"x\":\"2023-03-29T00:00:00\",\"y\":2256\},\{\"x\":\"2023-03-30T00:00:00\",\"y\":2047\},\{\"x\":\"2023-03-31T00:00:00\",\"y\":1705\},\{\"x\":\"2023-04-01T00:00:00\",\"y\":1568\},\{\"x\":\"2023-04-02T00:00:00\",\"y\":1521\},\{\"x\":\"2023-04-03T00:00:00\",\"y\":1505\},\{\"x\":\"2023-04-04T00:00:00\",\"y\":1527\},\{\"x\":\"2023-04-05T00:00:00\",\"y\":1537\},\{\"x\":\"2023-04-06T00:00:00\",\"y\":1601\},\{\"x\":\"2023-04-07T00:00:00\",\"y\":1704\},\{\"x\":\"2023-04-08T00:00:00\",\"y\":1785\},\{\"x\":\"2023-04-09T00:00:00\",\"y\":1898\},\{\"x\":\"2023-04-10T00:00:00\",\"y\":1998\}]\},\{\"type\":\"datatag\",\"name\":\"SDT\",\"value\":\"local/datatable//plugins/servlet/epm//eigen-webtools-servlet/sqlquery?&cmd=EXECUTE&db=ecnor-db&query= with P as (select DAYTIME as DAYTIME, SUM(DEFFERED_OIL) as STD from ZV_DEFERMENT where DAYTIME between (select TRUNC (sysdate,\'YEAR\') from DUAL) and (select TRUNC (CURRENT_DATE) from DUAL) and SCHED_UNSCHED = \'Scheduled\' and UPPER(CAUSE_GROUP) not like \'%25IDLE%25\' group by DAYTIME ), Q as ( SELECT ((select TRUNC (sysdate,\'YEAR\') from DUAL) %2B (LEVEL - 1)) AS DAYTIME, (select 0 from dual) as ZERO FROM DUAL connect by level <=( sysdate-((select TRUNC (sysdate,\'YEAR\') from DUAL))) ) SELECT concat(to_char(Q.DAYTIME,\'YYYY-MM-DD\'),\'T00:00:00\') as %22x%22, coalesce(P.STD,0) as %22y%22 FROM Q LEFT JOIN P ON Q.DAYTIME = P.DAYTIME order by Q.DAYTIME\",\"description\":\"\",\"metaData\":\{\},\"hidden\":false,\"status\":\{\"_params\":\{\"contexts\":\{\}\}\},\"units\":\"sm3\",\"enumerated\":null,\"replacements\":\{\"reporttime\":\"1673305199000\"\},\"localData\":[\{\"x\":\"2023-01-01T00:00:00\",\"y\":120\},\{\"x\":\"2023-01-02T00:00:00\",\"y\":80\},\{\"x\":\"2023-01-03T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-04T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-05T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-06T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-07T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-08T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-09T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-10T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-11T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-12T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-13T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-14T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-15T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-16T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-17T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-18T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-19T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-20T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-21T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-22T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-23T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-24T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-25T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-26T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-27T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-28T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-29T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-30T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-31T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-01T00:00:00\",\"y\":50\},\{\"x\":\"2023-02-02T00:00:00\",\"y\":200\},\{\"x\":\"2023-02-03T00:00:00\",\"y\":200\},\{\"x\":\"2023-02-04T00:00:00\",\"y\":200\},\{\"x\":\"2023-02-05T00:00:00\",\"y\":200\},\{\"x\":\"2023-02-06T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-07T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-08T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-09T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-10T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-11T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-12T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-13T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-14T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-15T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-16T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-17T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-18T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-19T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-20T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-21T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-22T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-23T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-24T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-25T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-26T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-27T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-28T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-01T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-02T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-03T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-04T00:00:00\",\"y\":200\},\{\"x\":\"2023-03-05T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-06T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-07T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-08T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-09T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-10T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-11T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-12T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-13T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-14T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-15T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-16T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-17T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-18T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-19T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-20T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-21T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-22T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-23T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-24T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-25T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-26T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-27T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-28T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-29T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-30T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-31T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-01T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-02T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-03T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-04T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-05T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-06T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-07T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-08T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-09T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-10T00:00:00\",\"y\":0\}]\},\{\"type\":\"datatag\",\"name\":\"UDT\",\"value\":\"local/datatable//plugins/servlet/epm//eigen-webtools-servlet/sqlquery?&cmd=EXECUTE&db=ecnor-db&query= with P as (select DAYTIME as DAYTIME, SUM(DEFFERED_OIL) as STD from ZV_DEFERMENT where DAYTIME between (select TRUNC (sysdate,\'YEAR\') from DUAL) and (select TRUNC (CURRENT_DATE) from DUAL) and SCHED_UNSCHED = \'Unscheduled\' and UPPER(CAUSE_GROUP) not like \'%25IDLE%25\' group by DAYTIME ), Q as ( SELECT ((select TRUNC (sysdate,\'YEAR\') from DUAL) %2B (LEVEL - 1)) AS DAYTIME, (select 0 from dual) as ZERO FROM DUAL connect by level <=( sysdate-((select TRUNC (sysdate,\'YEAR\') from DUAL))) ) SELECT concat(to_char(Q.DAYTIME,\'YYYY-MM-DD\'),\'T00:00:00\') as %22x%22, round(coalesce(P.STD,0),0) as %22y%22 FROM Q LEFT JOIN P ON Q.DAYTIME = P.DAYTIME order by Q.DAYTIME\",\"description\":\"\",\"metaData\":\{\},\"hidden\":false,\"status\":\{\"_params\":\{\"contexts\":\{\}\}\},\"units\":\"sm3\",\"enumerated\":null,\"replacements\":\{\"reporttime\":\"1673305199000\"\},\"localData\":[\{\"x\":\"2023-01-01T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-02T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-03T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-04T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-05T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-06T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-07T00:00:00\",\"y\":860\},\{\"x\":\"2023-01-08T00:00:00\",\"y\":1800\},\{\"x\":\"2023-01-09T00:00:00\",\"y\":1560\},\{\"x\":\"2023-01-10T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-11T00:00:00\",\"y\":420\},\{\"x\":\"2023-01-12T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-13T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-14T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-15T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-16T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-17T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-18T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-19T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-20T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-21T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-22T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-23T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-24T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-25T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-26T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-27T00:00:00\",\"y\":1800\},\{\"x\":\"2023-01-28T00:00:00\",\"y\":1670\},\{\"x\":\"2023-01-29T00:00:00\",\"y\":500\},\{\"x\":\"2023-01-30T00:00:00\",\"y\":470\},\{\"x\":\"2023-01-31T00:00:00\",\"y\":420\},\{\"x\":\"2023-02-01T00:00:00\",\"y\":320\},\{\"x\":\"2023-02-02T00:00:00\",\"y\":220\},\{\"x\":\"2023-02-03T00:00:00\",\"y\":220\},\{\"x\":\"2023-02-04T00:00:00\",\"y\":220\},\{\"x\":\"2023-02-05T00:00:00\",\"y\":220\},\{\"x\":\"2023-02-06T00:00:00\",\"y\":220\},\{\"x\":\"2023-02-07T00:00:00\",\"y\":220\},\{\"x\":\"2023-02-08T00:00:00\",\"y\":760\},\{\"x\":\"2023-02-09T00:00:00\",\"y\":220\},\{\"x\":\"2023-02-10T00:00:00\",\"y\":1070\},\{\"x\":\"2023-02-11T00:00:00\",\"y\":1070\},\{\"x\":\"2023-02-12T00:00:00\",\"y\":1070\},\{\"x\":\"2023-02-13T00:00:00\",\"y\":1070\},\{\"x\":\"2023-02-14T00:00:00\",\"y\":1070\},\{\"x\":\"2023-02-15T00:00:00\",\"y\":1070\},\{\"x\":\"2023-02-16T00:00:00\",\"y\":1070\},\{\"x\":\"2023-02-17T00:00:00\",\"y\":1070\},\{\"x\":\"2023-02-18T00:00:00\",\"y\":1070\},\{\"x\":\"2023-02-19T00:00:00\",\"y\":1070\},\{\"x\":\"2023-02-20T00:00:00\",\"y\":1070\},\{\"x\":\"2023-02-21T00:00:00\",\"y\":850\},\{\"x\":\"2023-02-22T00:00:00\",\"y\":850\},\{\"x\":\"2023-02-23T00:00:00\",\"y\":850\},\{\"x\":\"2023-02-24T00:00:00\",\"y\":850\},\{\"x\":\"2023-02-25T00:00:00\",\"y\":850\},\{\"x\":\"2023-02-26T00:00:00\",\"y\":850\},\{\"x\":\"2023-02-27T00:00:00\",\"y\":850\},\{\"x\":\"2023-02-28T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-01T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-02T00:00:00\",\"y\":1065\},\{\"x\":\"2023-03-03T00:00:00\",\"y\":1065\},\{\"x\":\"2023-03-04T00:00:00\",\"y\":1065\},\{\"x\":\"2023-03-05T00:00:00\",\"y\":1065\},\{\"x\":\"2023-03-06T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-07T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-08T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-09T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-10T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-11T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-12T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-13T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-14T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-15T00:00:00\",\"y\":1150\},\{\"x\":\"2023-03-16T00:00:00\",\"y\":950\},\{\"x\":\"2023-03-17T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-18T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-19T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-20T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-21T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-22T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-23T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-24T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-25T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-26T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-27T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-28T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-29T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-30T00:00:00\",\"y\":1016\},\{\"x\":\"2023-03-31T00:00:00\",\"y\":1217\},\{\"x\":\"2023-04-01T00:00:00\",\"y\":1217\},\{\"x\":\"2023-04-02T00:00:00\",\"y\":1217\},\{\"x\":\"2023-04-03T00:00:00\",\"y\":1217\},\{\"x\":\"2023-04-04T00:00:00\",\"y\":1217\},\{\"x\":\"2023-04-05T00:00:00\",\"y\":1217\},\{\"x\":\"2023-04-06T00:00:00\",\"y\":1217\},\{\"x\":\"2023-04-07T00:00:00\",\"y\":1026\},\{\"x\":\"2023-04-08T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-09T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-10T00:00:00\",\"y\":0\}]\},\{\"type\":\"datatag\",\"name\":\"RNB\",\"value\":\"local/datatable//plugins/servlet/epm//eigen-webtools-servlet/sqlquery?&cmd=EXECUTE&db=ecnor-db&query= with P as ( select DAYTIME as DAYTIME,SUM(NET_OIL_RATE) as RNB from dv_PROD_FIELD_FORECAST FF where ff.DAYTIME between (select TRUNC (sysdate,\'YEAR\') from DUAL) and (select ADD_MONTHS(TRUNC (sysdate,\'YEAR\'),12) from DUAL) and ff.FORECAST_TYPE = \'MONTH\' and ff.SCENARIO = \'BUDGET\' and FF.EFFECTIVE_DAYTIME = (SELECT MAX(FF.EFFECTIVE_DAYTIME) FROM dv_PROD_FIELD_FORECAST a WHERE a.OBJECT_CODE = FF.OBJECT_CODE) group by ff.DAYTIME ), Q as ( SELECT ((select TRUNC (sysdate,\'YEAR\') from DUAL) %2B (LEVEL -1)) AS DAYTIME, to_char(((select TRUNC (sysdate,\'YEAR\') from DUAL) %2B (LEVEL -1)),\'mm\') as MONTH FROM DUAL connect by level <=( (select ADD_MONTHS(TRUNC (sysdate,\'YEAR\'),12) from DUAL) - ((select TRUNC (sysdate,\'YEAR\') from DUAL))) ) SELECT concat(to_char(Q.DAYTIME,\'YYYY-MM-DD\'),\'T00:00:00\') as %22x%22, first_value(P.RNB) over (partition by Q.MONTH order by Q.DAYTIME) as %22y%22 FROM Q left JOIN P ON Q.DAYTIME = P.DAYTIME order by Q.DAYTIME\",\"description\":\"\",\"metaData\":\{\},\"hidden\":false,\"status\":\{\"_params\":\{\"contexts\":\{\}\}\},\"units\":\"sm3\",\"enumerated\":null,\"replacements\":\{\"reporttime\":\"1673305199000\"\},\"localData\":[\{\"x\":\"2023-01-01T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-02T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-03T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-04T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-05T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-06T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-07T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-08T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-09T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-10T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-11T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-12T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-13T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-14T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-15T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-16T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-17T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-18T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-19T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-20T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-21T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-22T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-23T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-24T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-25T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-26T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-27T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-28T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-29T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-30T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-31T00:00:00\",\"y\":3108\},\{\"x\":\"2023-02-01T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-02T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-03T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-04T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-05T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-06T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-07T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-08T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-09T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-10T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-11T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-12T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-13T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-14T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-15T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-16T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-17T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-18T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-19T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-20T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-21T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-22T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-23T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-24T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-25T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-26T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-27T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-28T00:00:00\",\"y\":2981\},\{\"x\":\"2023-03-01T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-02T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-03T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-04T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-05T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-06T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-07T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-08T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-09T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-10T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-11T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-12T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-13T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-14T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-15T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-16T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-17T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-18T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-19T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-20T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-21T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-22T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-23T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-24T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-25T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-26T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-27T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-28T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-29T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-30T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-31T00:00:00\",\"y\":3749\},\{\"x\":\"2023-04-01T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-02T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-03T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-04T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-05T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-06T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-07T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-08T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-09T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-10T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-11T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-12T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-13T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-14T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-15T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-16T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-17T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-18T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-19T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-20T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-21T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-22T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-23T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-24T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-25T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-26T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-27T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-28T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-29T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-30T00:00:00\",\"y\":3974\},\{\"x\":\"2023-05-01T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-02T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-03T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-04T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-05T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-06T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-07T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-08T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-09T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-10T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-11T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-12T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-13T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-14T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-15T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-16T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-17T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-18T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-19T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-20T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-21T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-22T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-23T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-24T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-25T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-26T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-27T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-28T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-29T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-30T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-31T00:00:00\",\"y\":3274\},\{\"x\":\"2023-06-01T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-02T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-03T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-04T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-05T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-06T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-07T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-08T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-09T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-10T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-11T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-12T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-13T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-14T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-15T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-16T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-17T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-18T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-19T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-20T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-21T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-22T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-23T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-24T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-25T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-26T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-27T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-28T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-29T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-30T00:00:00\",\"y\":3880\},\{\"x\":\"2023-07-01T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-02T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-03T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-04T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-05T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-06T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-07T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-08T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-09T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-10T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-11T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-12T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-13T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-14T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-15T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-16T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-17T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-18T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-19T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-20T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-21T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-22T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-23T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-24T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-25T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-26T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-27T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-28T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-29T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-30T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-31T00:00:00\",\"y\":4166\},\{\"x\":\"2023-08-01T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-02T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-03T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-04T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-05T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-06T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-07T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-08T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-09T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-10T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-11T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-12T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-13T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-14T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-15T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-16T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-17T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-18T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-19T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-20T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-21T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-22T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-23T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-24T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-25T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-26T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-27T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-28T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-29T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-30T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-31T00:00:00\",\"y\":1654\},\{\"x\":\"2023-09-01T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-02T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-03T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-04T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-05T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-06T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-07T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-08T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-09T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-10T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-11T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-12T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-13T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-14T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-15T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-16T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-17T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-18T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-19T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-20T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-21T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-22T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-23T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-24T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-25T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-26T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-27T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-28T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-29T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-30T00:00:00\",\"y\":3209\},\{\"x\":\"2023-10-01T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-02T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-03T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-04T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-05T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-06T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-07T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-08T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-09T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-10T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-11T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-12T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-13T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-14T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-15T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-16T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-17T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-18T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-19T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-20T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-21T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-22T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-23T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-24T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-25T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-26T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-27T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-28T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-29T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-30T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-31T00:00:00\",\"y\":3851\},\{\"x\":\"2023-11-01T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-02T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-03T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-04T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-05T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-06T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-07T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-08T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-09T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-10T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-11T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-12T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-13T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-14T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-15T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-16T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-17T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-18T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-19T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-20T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-21T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-22T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-23T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-24T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-25T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-26T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-27T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-28T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-29T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-30T00:00:00\",\"y\":4506\},\{\"x\":\"2023-12-01T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-02T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-03T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-04T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-05T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-06T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-07T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-08T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-09T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-10T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-11T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-12T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-13T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-14T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-15T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-16T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-17T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-18T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-19T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-20T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-21T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-22T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-23T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-24T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-25T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-26T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-27T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-28T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-29T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-30T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-31T00:00:00\",\"y\":4539\}]\},\{\"type\":\"datatag\",\"name\":\"FC\",\"value\":\"local/datatable//plugins/servlet/epm//eigen-webtools-servlet/sqlquery?&cmd=EXECUTE&db=ecnor-db&query= with P as ( select DAYTIME as DAYTIME,SUM(NET_OIL_RATE) as FC from dv_PROD_FIELD_FORECAST FF where ff.DAYTIME between (select TRUNC (sysdate,\'YEAR\') from DUAL) and (select ADD_MONTHS(TRUNC (sysdate,\'YEAR\'),12) from DUAL) and ff.FORECAST_TYPE = \'MONTH\' and ff.SCENARIO = \'FORECAST\' and FF.EFFECTIVE_DAYTIME = (SELECT MAX(EFFECTIVE_DAYTIME) FROM dv_PROD_FIELD_FORECAST a WHERE a.OBJECT_CODE = FF.OBJECT_CODE) group by ff.DAYTIME ), Q as ( SELECT ((select TRUNC (sysdate,\'YEAR\') from DUAL) %2B (LEVEL -1)) AS DAYTIME, to_char(((select TRUNC (sysdate,\'YEAR\') from DUAL) %2B (LEVEL -1)),\'mm\') as MONTH FROM DUAL connect by level <=( (select ADD_MONTHS(TRUNC (sysdate,\'YEAR\'),12) from DUAL) - ((select TRUNC (sysdate,\'YEAR\') from DUAL))) ) SELECT concat(to_char(Q.DAYTIME,\'YYYY-MM-DD\'),\'T00:00:00\') as %22x%22, first_value(P.FC) over (partition by Q.MONTH order by Q.DAYTIME) as %22y%22 FROM Q left JOIN P ON Q.DAYTIME = P.DAYTIME order by Q.DAYTIME\",\"description\":\"\",\"metaData\":\{\},\"hidden\":false,\"status\":\{\"_params\":\{\"contexts\":\{\}\}\},\"units\":\"sm3\",\"enumerated\":null,\"replacements\":\{\"reporttime\":\"1673305199000\"\},\"localData\":[\{\"x\":\"2023-01-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-29T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-30T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-31T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-29T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-30T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-31T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-29T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-30T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-29T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-30T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-31T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-29T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-30T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-29T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-30T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-31T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-29T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-30T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-31T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-29T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-30T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-29T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-30T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-31T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-29T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-30T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-29T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-30T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-31T00:00:00\",\"y\":null\}]\}],\"axes\":[\{\"side\":\"left\",\"num\":0,\"min\":\"auto\",\"max\":\"auto\",\"format\":\"auto\",\"step\":\"auto\",\"units\":\"sm3\",\"colour\":\"#84C661\",\"type\":\"step-before\",\"reference\":null,\"stacked\":true,\"style\":1,\"linestyle\":1,\"lineWidth\":\"1.5\",\"hideFuture\":1681081199000,\"groupType\":\"none\",\"groupFunctionType\":\"first\",\"maxLabelWidth\":80,\"meta\":\{\}\},\{\"side\":\"left\",\"num\":0,\"min\":\"auto\",\"max\":\"auto\",\"format\":\"auto\",\"step\":\"auto\",\"units\":\"sm3\",\"colour\":\"#42A4FF\",\"type\":\"step-before\",\"reference\":null,\"stacked\":true,\"style\":1,\"linestyle\":1,\"lineWidth\":\"1.5\",\"hideFuture\":1681081199000,\"groupType\":\"none\",\"groupFunctionType\":\"first\",\"maxLabelWidth\":80,\"meta\":\{\}\},\{\"side\":\"left\",\"num\":0,\"min\":\"auto\",\"max\":\"auto\",\"format\":\"auto\",\"step\":\"auto\",\"units\":\"sm3\",\"colour\":\"#BBC6C7\",\"type\":\"step-before\",\"reference\":null,\"stacked\":true,\"style\":1,\"linestyle\":1,\"lineWidth\":\"1.5\",\"hideFuture\":1681081199000,\"groupType\":\"none\",\"groupFunctionType\":\"first\",\"maxLabelWidth\":80,\"meta\":\{\}\},\{\"side\":\"left\",\"num\":0,\"min\":\"auto\",\"max\":\"auto\",\"format\":\"auto\",\"step\":\"auto\",\"units\":\"sm3\",\"colour\":\"#002F5C\",\"type\":\"step-after\",\"reference\":null,\"stacked\":false,\"style\":1,\"linestyle\":1,\"lineWidth\":\"1.5\",\"hideFuture\":false,\"groupType\":\"none\",\"groupFunctionType\":\"average\",\"maxLabelWidth\":80,\"meta\":\{\}\},\{\"side\":\"left\",\"num\":0,\"min\":\"auto\",\"max\":\"auto\",\"format\":\"auto\",\"step\":\"auto\",\"units\":\"sm3\",\"colour\":\"#840029\",\"type\":\"step-before\",\"reference\":null,\"stacked\":false,\"style\":1,\"linestyle\":1,\"lineWidth\":\"1.5\",\"hideFuture\":false,\"groupType\":\"none\",\"groupFunctionType\":\"average\",\"maxLabelWidth\":80,\"meta\":\{\}\}],\"modes\":[\{\"mode\":\"raw\"\},\{\"mode\":\"raw\"\},\{\"mode\":\"raw\"\},\{\"mode\":\"raw\"\},\{\"mode\":\"raw\"\}],\"bounds\":[1672527600000,1704063600000],\"boundsHistory\":[],\"live\":true,\"liveOffset\":\"\",\"liveSnapTo\":\"year\",\"refreshRate\":\"auto\",\"sync\":false,\"title\":\{\"main\":\"\",\"sub\":\"\",\"fgcolour\":\"#333333\",\"bgcolour\":\"#ffffff\",\"size\":\"24\",\"alignment\":\"center\"\},\"seamless\":true,\"locked\":true,\"tz\":\"Europe/Oslo\",\"ampm\":false,\"numPoints\":1000,\"useCache\":true,\"savedPoints\":[],\"type\":\"line\",\"allowExternalChanges\":false,\"scaleToFillHeight\":false,\"noLabelPrefixes\":false,\"enableTimeWindowShortcuts\":false,\"timeWindowShortcuts\":null,\"theme\":null,\"hideLegend\":false,\"hideYAxes\":false,\"hideXAxes\":false,\"isTimeBased\":true,\"invertAxes\":false,\"includeStats\":false,\"defaultMargin\":false\}],\"vars\":\{\"reporttime\":\{\"value\":\"1673305199000\"\}\},\"tags\":[\"dpr\"],\"promptIfDirtyClose\":true\}

Epm macro editor
config\{\"promptIfDirtyClose\":true,\"seamless\":true,\"editor\":\{\"html\":\"%3Cdiv%20style%3D%5C%22width%3A%20100vw%3B%20height%3A%20100vh%3B%5C%22%3Ecomments%3C%2Fdiv%3E\"\},\"tags\":[\"dpr\"]\}

Epm macro editor
config\{\"seamless\":true,\"editor\":\{\"html\":\"%3Cdiv%20style%3D%5C%22color%3A%20black%3B%20height%3A%2040px%3B%20align-items%3A%20center%3B%20display%3A%20flex%3B%20justify-content%3A%20center%3B%20border-bottom%3A%200.5px%20solid%20black%3B%20font-weight%3A%20bold%3B%20font-size%3A%2020px%3B%20page-break-before%3A%20always%3B%5C%22%3EYearly%20Figures%3C%2Fdiv%3E\"\},\"tags\":[\"dpr\"],\"promptIfDirtyClose\":true\}

Epm macro editor
config\{\"seamless\":true,\"editor\":\{\"html\":\"%3Ctable%20style%3D%5C%22width%3A%20100o-o%3B%20border-collapse%3A%20collapse%3B%20border-style%3A%20hidden%3B%20background-color%3A%20%2384c561%3B%20height%3A%2036px%3B%5C%22%20border%3D%5C%221%5C%22%3E%0A%3Ctbody%3E%0A%3Ctr%20style%3D%5C%22text-align%3A%20left%3B%5C%22%3E%0A%3Ctd%20style%3D%5C%22width%3A%20100o-o%3B%20height%3A%2036px%3B%20background-color%3A%20%2384c561%3B%20text-align%3A%20left%3B%20vertical-align%3A%20middle%3B%5C%22%20scope%3D%5C%22row%5C%22%3E%3Cspan%20style%3D%5C%22color%3A%20%23ffffff%3B%5C%22%3E%3Cstrong%3E%26nbsp%3B%20%3Cspan%20style%3D%5C%22color%3A%20%231d1d1d%3B%5C%22%3EBalder%2FRinghorne%20gross%20oil%20production%3C%2Fspan%3E%3C%2Fstrong%3E%3C%2Fspan%3E%3C%2Ftd%3E%0A%3C%2Ftr%3E%0A%3C%2Ftbody%3E%0A%3C%2Ftable%3E\"\},\"tags\":[\"dpr\"],\"promptIfDirtyClose\":true\}
Epm macro trendmultichart
config\{\"layout\":0,\"height\":482,\"width\":0,\"seamless\":true,\"sync\":false,\"charts\":[\{\"trends\":[\{\"type\":\"datatag\",\"name\":\"AP\",\"value\":\"local/datatable//plugins/servlet/epm//eigen-webtools-servlet/sqlquery?&cmd=EXECUTE&db=ecnor-db&query= with P as (select DAYTIME as DAYTIME, SUM(NET_VOL) as AP from dv_strm_day_pc_alloc where DAYTIME between (select TRUNC (sysdate,\'YEAR\') from DUAL) and (select TRUNC (CURRENT_DATE) from DUAL) and OBJECT_CODE = \'BAL1001\' and PROFIT_CENTRE_CODE in (\'BALDER_FIELD\', \'RHE_FIELD\', \'RH_FIELD\') group by DAYTIME ), Q as ( SELECT ((select TRUNC (sysdate,\'YEAR\') from DUAL) %2B (LEVEL - 1)) AS DAYTIME, (select 0 from dual) as ZERO FROM DUAL connect by level <=( sysdate-((select TRUNC (sysdate,\'YEAR\') from DUAL))) ) SELECT concat(to_char(Q.DAYTIME,\'YYYY-MM-DD\'),\'T00:00:00\') as %22x%22, round(coalesce(P.AP,0),0) as %22y%22 FROM Q LEFT JOIN P ON Q.DAYTIME = P.DAYTIME order by Q.DAYTIME\",\"description\":\"\",\"metaData\":\{\},\"hidden\":false,\"status\":\{\"_params\":\{\"contexts\":\{\}\}\},\"units\":\"sm3\",\"enumerated\":null,\"replacements\":\{\"reporttime\":\"1673305199000\"\},\"localData\":[\{\"x\":\"2023-01-01T00:00:00\",\"y\":2608\},\{\"x\":\"2023-01-02T00:00:00\",\"y\":2704\},\{\"x\":\"2023-01-03T00:00:00\",\"y\":2980\},\{\"x\":\"2023-01-04T00:00:00\",\"y\":3091\},\{\"x\":\"2023-01-05T00:00:00\",\"y\":3608\},\{\"x\":\"2023-01-06T00:00:00\",\"y\":3611\},\{\"x\":\"2023-01-07T00:00:00\",\"y\":3030\},\{\"x\":\"2023-01-08T00:00:00\",\"y\":1890\},\{\"x\":\"2023-01-09T00:00:00\",\"y\":2071\},\{\"x\":\"2023-01-10T00:00:00\",\"y\":3270\},\{\"x\":\"2023-01-11T00:00:00\",\"y\":3458\},\{\"x\":\"2023-01-12T00:00:00\",\"y\":3449\},\{\"x\":\"2023-01-13T00:00:00\",\"y\":3461\},\{\"x\":\"2023-01-14T00:00:00\",\"y\":3461\},\{\"x\":\"2023-01-15T00:00:00\",\"y\":3474\},\{\"x\":\"2023-01-16T00:00:00\",\"y\":3570\},\{\"x\":\"2023-01-17T00:00:00\",\"y\":3627\},\{\"x\":\"2023-01-18T00:00:00\",\"y\":3659\},\{\"x\":\"2023-01-19T00:00:00\",\"y\":3604\},\{\"x\":\"2023-01-20T00:00:00\",\"y\":3558\},\{\"x\":\"2023-01-21T00:00:00\",\"y\":3627\},\{\"x\":\"2023-01-22T00:00:00\",\"y\":3688\},\{\"x\":\"2023-01-23T00:00:00\",\"y\":3418\},\{\"x\":\"2023-01-24T00:00:00\",\"y\":3513\},\{\"x\":\"2023-01-25T00:00:00\",\"y\":3486\},\{\"x\":\"2023-01-26T00:00:00\",\"y\":3455\},\{\"x\":\"2023-01-27T00:00:00\",\"y\":1799\},\{\"x\":\"2023-01-28T00:00:00\",\"y\":1925\},\{\"x\":\"2023-01-29T00:00:00\",\"y\":3182\},\{\"x\":\"2023-01-30T00:00:00\",\"y\":3190\},\{\"x\":\"2023-01-31T00:00:00\",\"y\":3226\},\{\"x\":\"2023-02-01T00:00:00\",\"y\":3284\},\{\"x\":\"2023-02-02T00:00:00\",\"y\":3318\},\{\"x\":\"2023-02-03T00:00:00\",\"y\":3434\},\{\"x\":\"2023-02-04T00:00:00\",\"y\":3375\},\{\"x\":\"2023-02-05T00:00:00\",\"y\":3372\},\{\"x\":\"2023-02-06T00:00:00\",\"y\":3561\},\{\"x\":\"2023-02-07T00:00:00\",\"y\":3538\},\{\"x\":\"2023-02-08T00:00:00\",\"y\":3555\},\{\"x\":\"2023-02-09T00:00:00\",\"y\":2979\},\{\"x\":\"2023-02-10T00:00:00\",\"y\":2593\},\{\"x\":\"2023-02-11T00:00:00\",\"y\":2662\},\{\"x\":\"2023-02-12T00:00:00\",\"y\":2750\},\{\"x\":\"2023-02-13T00:00:00\",\"y\":2798\},\{\"x\":\"2023-02-14T00:00:00\",\"y\":2709\},\{\"x\":\"2023-02-15T00:00:00\",\"y\":2698\},\{\"x\":\"2023-02-16T00:00:00\",\"y\":2669\},\{\"x\":\"2023-02-17T00:00:00\",\"y\":2562\},\{\"x\":\"2023-02-18T00:00:00\",\"y\":2528\},\{\"x\":\"2023-02-19T00:00:00\",\"y\":2467\},\{\"x\":\"2023-02-20T00:00:00\",\"y\":2436\},\{\"x\":\"2023-02-21T00:00:00\",\"y\":2528\},\{\"x\":\"2023-02-22T00:00:00\",\"y\":2515\},\{\"x\":\"2023-02-23T00:00:00\",\"y\":2504\},\{\"x\":\"2023-02-24T00:00:00\",\"y\":2522\},\{\"x\":\"2023-02-25T00:00:00\",\"y\":2539\},\{\"x\":\"2023-02-26T00:00:00\",\"y\":2503\},\{\"x\":\"2023-02-27T00:00:00\",\"y\":2465\},\{\"x\":\"2023-02-28T00:00:00\",\"y\":2513\},\{\"x\":\"2023-03-01T00:00:00\",\"y\":2774\},\{\"x\":\"2023-03-02T00:00:00\",\"y\":2258\},\{\"x\":\"2023-03-03T00:00:00\",\"y\":2189\},\{\"x\":\"2023-03-04T00:00:00\",\"y\":2420\},\{\"x\":\"2023-03-05T00:00:00\",\"y\":2450\},\{\"x\":\"2023-03-06T00:00:00\",\"y\":2605\},\{\"x\":\"2023-03-07T00:00:00\",\"y\":2639\},\{\"x\":\"2023-03-08T00:00:00\",\"y\":2577\},\{\"x\":\"2023-03-09T00:00:00\",\"y\":2624\},\{\"x\":\"2023-03-10T00:00:00\",\"y\":2649\},\{\"x\":\"2023-03-11T00:00:00\",\"y\":2581\},\{\"x\":\"2023-03-12T00:00:00\",\"y\":2582\},\{\"x\":\"2023-03-13T00:00:00\",\"y\":2575\},\{\"x\":\"2023-03-14T00:00:00\",\"y\":2539\},\{\"x\":\"2023-03-15T00:00:00\",\"y\":2242\},\{\"x\":\"2023-03-16T00:00:00\",\"y\":2335\},\{\"x\":\"2023-03-17T00:00:00\",\"y\":2520\},\{\"x\":\"2023-03-18T00:00:00\",\"y\":2427\},\{\"x\":\"2023-03-19T00:00:00\",\"y\":2459\},\{\"x\":\"2023-03-20T00:00:00\",\"y\":2494\},\{\"x\":\"2023-03-21T00:00:00\",\"y\":2443\},\{\"x\":\"2023-03-22T00:00:00\",\"y\":2369\},\{\"x\":\"2023-03-23T00:00:00\",\"y\":2338\},\{\"x\":\"2023-03-24T00:00:00\",\"y\":2326\},\{\"x\":\"2023-03-25T00:00:00\",\"y\":2286\},\{\"x\":\"2023-03-26T00:00:00\",\"y\":2214\},\{\"x\":\"2023-03-27T00:00:00\",\"y\":2288\},\{\"x\":\"2023-03-28T00:00:00\",\"y\":2257\},\{\"x\":\"2023-03-29T00:00:00\",\"y\":2256\},\{\"x\":\"2023-03-30T00:00:00\",\"y\":2047\},\{\"x\":\"2023-03-31T00:00:00\",\"y\":1705\},\{\"x\":\"2023-04-01T00:00:00\",\"y\":1568\},\{\"x\":\"2023-04-02T00:00:00\",\"y\":1521\},\{\"x\":\"2023-04-03T00:00:00\",\"y\":1505\},\{\"x\":\"2023-04-04T00:00:00\",\"y\":1527\},\{\"x\":\"2023-04-05T00:00:00\",\"y\":1537\},\{\"x\":\"2023-04-06T00:00:00\",\"y\":1601\},\{\"x\":\"2023-04-07T00:00:00\",\"y\":1704\},\{\"x\":\"2023-04-08T00:00:00\",\"y\":1785\},\{\"x\":\"2023-04-09T00:00:00\",\"y\":1898\},\{\"x\":\"2023-04-10T00:00:00\",\"y\":1998\}]\},\{\"type\":\"datatag\",\"name\":\"SDT\",\"value\":\"local/datatable//plugins/servlet/epm//eigen-webtools-servlet/sqlquery?&cmd=EXECUTE&db=ecnor-db&query= with P as (select DAYTIME as DAYTIME, SUM(DEFFERED_OIL) as STD from ZV_DEFERMENT where DAYTIME between (select TRUNC (sysdate,\'YEAR\') from DUAL) and (select TRUNC (CURRENT_DATE) from DUAL) and SCHED_UNSCHED = \'Scheduled\' and UPPER(CAUSE_GROUP) not like \'%25IDLE%25\' group by DAYTIME ), Q as ( SELECT ((select TRUNC (sysdate,\'YEAR\') from DUAL) %2B (LEVEL - 1)) AS DAYTIME, (select 0 from dual) as ZERO FROM DUAL connect by level <=( sysdate-((select TRUNC (sysdate,\'YEAR\') from DUAL))) ) SELECT concat(to_char(Q.DAYTIME,\'YYYY-MM-DD\'),\'T00:00:00\') as %22x%22, coalesce(P.STD,0) as %22y%22 FROM Q LEFT JOIN P ON Q.DAYTIME = P.DAYTIME order by Q.DAYTIME\",\"description\":\"\",\"metaData\":\{\},\"hidden\":false,\"status\":\{\"_params\":\{\"contexts\":\{\}\}\},\"units\":\"sm3\",\"enumerated\":null,\"replacements\":\{\"reporttime\":\"1673305199000\"\},\"localData\":[\{\"x\":\"2023-01-01T00:00:00\",\"y\":120\},\{\"x\":\"2023-01-02T00:00:00\",\"y\":80\},\{\"x\":\"2023-01-03T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-04T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-05T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-06T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-07T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-08T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-09T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-10T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-11T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-12T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-13T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-14T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-15T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-16T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-17T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-18T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-19T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-20T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-21T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-22T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-23T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-24T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-25T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-26T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-27T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-28T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-29T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-30T00:00:00\",\"y\":0\},\{\"x\":\"2023-01-31T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-01T00:00:00\",\"y\":50\},\{\"x\":\"2023-02-02T00:00:00\",\"y\":200\},\{\"x\":\"2023-02-03T00:00:00\",\"y\":200\},\{\"x\":\"2023-02-04T00:00:00\",\"y\":200\},\{\"x\":\"2023-02-05T00:00:00\",\"y\":200\},\{\"x\":\"2023-02-06T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-07T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-08T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-09T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-10T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-11T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-12T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-13T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-14T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-15T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-16T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-17T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-18T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-19T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-20T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-21T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-22T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-23T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-24T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-25T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-26T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-27T00:00:00\",\"y\":0\},\{\"x\":\"2023-02-28T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-01T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-02T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-03T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-04T00:00:00\",\"y\":200\},\{\"x\":\"2023-03-05T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-06T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-07T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-08T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-09T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-10T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-11T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-12T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-13T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-14T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-15T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-16T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-17T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-18T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-19T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-20T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-21T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-22T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-23T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-24T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-25T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-26T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-27T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-28T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-29T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-30T00:00:00\",\"y\":0\},\{\"x\":\"2023-03-31T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-01T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-02T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-03T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-04T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-05T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-06T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-07T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-08T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-09T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-10T00:00:00\",\"y\":0\}]\},\{\"type\":\"datatag\",\"name\":\"UDT\",\"value\":\"local/datatable//plugins/servlet/epm//eigen-webtools-servlet/sqlquery?&cmd=EXECUTE&db=ecnor-db&query= with P as (select DAYTIME as DAYTIME, SUM(DEFFERED_OIL) as STD from ZV_DEFERMENT where DAYTIME between (select TRUNC (sysdate,\'YEAR\') from DUAL) and (select TRUNC (CURRENT_DATE) from DUAL) and SCHED_UNSCHED = \'Unscheduled\' and UPPER(CAUSE_GROUP) not like \'%25IDLE%25\' group by DAYTIME ), Q as ( SELECT ((select TRUNC (sysdate,\'YEAR\') from DUAL) %2B (LEVEL - 1)) AS DAYTIME, (select 0 from dual) as ZERO FROM DUAL connect by level <=( sysdate-((select TRUNC (sysdate,\'YEAR\') from DUAL))) ) SELECT concat(to_char(Q.DAYTIME,\'YYYY-MM-DD\'),\'T00:00:00\') as %22x%22, round(coalesce(P.STD,0),0) as %22y%22 FROM Q LEFT JOIN P ON Q.DAYTIME = P.DAYTIME order by Q.DAYTIME\",\"description\":\"\",\"metaData\":\{\},\"hidden\":false,\"status\":\{\"_params\":\{\"contexts\":\{\}\}\},\"units\":\"sm3\",\"enumerated\":null,\"replacements\":\{\"reporttime\":\"1673305199000\"\},\"localData\":[\{\"x\":\"2023-01-01T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-02T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-03T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-04T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-05T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-06T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-07T00:00:00\",\"y\":860\},\{\"x\":\"2023-01-08T00:00:00\",\"y\":1800\},\{\"x\":\"2023-01-09T00:00:00\",\"y\":1560\},\{\"x\":\"2023-01-10T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-11T00:00:00\",\"y\":420\},\{\"x\":\"2023-01-12T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-13T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-14T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-15T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-16T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-17T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-18T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-19T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-20T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-21T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-22T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-23T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-24T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-25T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-26T00:00:00\",\"y\":220\},\{\"x\":\"2023-01-27T00:00:00\",\"y\":1800\},\{\"x\":\"2023-01-28T00:00:00\",\"y\":1670\},\{\"x\":\"2023-01-29T00:00:00\",\"y\":500\},\{\"x\":\"2023-01-30T00:00:00\",\"y\":470\},\{\"x\":\"2023-01-31T00:00:00\",\"y\":420\},\{\"x\":\"2023-02-01T00:00:00\",\"y\":320\},\{\"x\":\"2023-02-02T00:00:00\",\"y\":220\},\{\"x\":\"2023-02-03T00:00:00\",\"y\":220\},\{\"x\":\"2023-02-04T00:00:00\",\"y\":220\},\{\"x\":\"2023-02-05T00:00:00\",\"y\":220\},\{\"x\":\"2023-02-06T00:00:00\",\"y\":220\},\{\"x\":\"2023-02-07T00:00:00\",\"y\":220\},\{\"x\":\"2023-02-08T00:00:00\",\"y\":760\},\{\"x\":\"2023-02-09T00:00:00\",\"y\":220\},\{\"x\":\"2023-02-10T00:00:00\",\"y\":1070\},\{\"x\":\"2023-02-11T00:00:00\",\"y\":1070\},\{\"x\":\"2023-02-12T00:00:00\",\"y\":1070\},\{\"x\":\"2023-02-13T00:00:00\",\"y\":1070\},\{\"x\":\"2023-02-14T00:00:00\",\"y\":1070\},\{\"x\":\"2023-02-15T00:00:00\",\"y\":1070\},\{\"x\":\"2023-02-16T00:00:00\",\"y\":1070\},\{\"x\":\"2023-02-17T00:00:00\",\"y\":1070\},\{\"x\":\"2023-02-18T00:00:00\",\"y\":1070\},\{\"x\":\"2023-02-19T00:00:00\",\"y\":1070\},\{\"x\":\"2023-02-20T00:00:00\",\"y\":1070\},\{\"x\":\"2023-02-21T00:00:00\",\"y\":850\},\{\"x\":\"2023-02-22T00:00:00\",\"y\":850\},\{\"x\":\"2023-02-23T00:00:00\",\"y\":850\},\{\"x\":\"2023-02-24T00:00:00\",\"y\":850\},\{\"x\":\"2023-02-25T00:00:00\",\"y\":850\},\{\"x\":\"2023-02-26T00:00:00\",\"y\":850\},\{\"x\":\"2023-02-27T00:00:00\",\"y\":850\},\{\"x\":\"2023-02-28T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-01T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-02T00:00:00\",\"y\":1065\},\{\"x\":\"2023-03-03T00:00:00\",\"y\":1065\},\{\"x\":\"2023-03-04T00:00:00\",\"y\":1065\},\{\"x\":\"2023-03-05T00:00:00\",\"y\":1065\},\{\"x\":\"2023-03-06T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-07T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-08T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-09T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-10T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-11T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-12T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-13T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-14T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-15T00:00:00\",\"y\":1150\},\{\"x\":\"2023-03-16T00:00:00\",\"y\":950\},\{\"x\":\"2023-03-17T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-18T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-19T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-20T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-21T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-22T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-23T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-24T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-25T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-26T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-27T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-28T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-29T00:00:00\",\"y\":850\},\{\"x\":\"2023-03-30T00:00:00\",\"y\":1016\},\{\"x\":\"2023-03-31T00:00:00\",\"y\":1217\},\{\"x\":\"2023-04-01T00:00:00\",\"y\":1217\},\{\"x\":\"2023-04-02T00:00:00\",\"y\":1217\},\{\"x\":\"2023-04-03T00:00:00\",\"y\":1217\},\{\"x\":\"2023-04-04T00:00:00\",\"y\":1217\},\{\"x\":\"2023-04-05T00:00:00\",\"y\":1217\},\{\"x\":\"2023-04-06T00:00:00\",\"y\":1217\},\{\"x\":\"2023-04-07T00:00:00\",\"y\":1026\},\{\"x\":\"2023-04-08T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-09T00:00:00\",\"y\":0\},\{\"x\":\"2023-04-10T00:00:00\",\"y\":0\}]\},\{\"type\":\"datatag\",\"name\":\"RNB\",\"value\":\"local/datatable//plugins/servlet/epm//eigen-webtools-servlet/sqlquery?&cmd=EXECUTE&db=ecnor-db&query= with P as ( select DAYTIME as DAYTIME,SUM(NET_OIL_RATE) as RNB from dv_PROD_FIELD_FORECAST FF where ff.DAYTIME between (select TRUNC (sysdate,\'YEAR\') from DUAL) and (select ADD_MONTHS(TRUNC (sysdate,\'YEAR\'),12) from DUAL) and ff.FORECAST_TYPE = \'MONTH\' and ff.SCENARIO = \'BUDGET\' and FF.EFFECTIVE_DAYTIME = (SELECT MAX(FF.EFFECTIVE_DAYTIME) FROM dv_PROD_FIELD_FORECAST a WHERE a.OBJECT_CODE = FF.OBJECT_CODE) group by ff.DAYTIME ), Q as ( SELECT ((select TRUNC (sysdate,\'YEAR\') from DUAL) %2B (LEVEL -1)) AS DAYTIME, to_char(((select TRUNC (sysdate,\'YEAR\') from DUAL) %2B (LEVEL -1)),\'mm\') as MONTH FROM DUAL connect by level <=( (select ADD_MONTHS(TRUNC (sysdate,\'YEAR\'),12) from DUAL) - ((select TRUNC (sysdate,\'YEAR\') from DUAL))) ) SELECT concat(to_char(Q.DAYTIME,\'YYYY-MM-DD\'),\'T00:00:00\') as %22x%22, first_value(P.RNB) over (partition by Q.MONTH order by Q.DAYTIME) as %22y%22 FROM Q left JOIN P ON Q.DAYTIME = P.DAYTIME order by Q.DAYTIME\",\"description\":\"\",\"metaData\":\{\},\"hidden\":false,\"status\":\{\"_params\":\{\"contexts\":\{\}\}\},\"units\":\"sm3\",\"enumerated\":null,\"replacements\":\{\"reporttime\":\"1673305199000\"\},\"localData\":[\{\"x\":\"2023-01-01T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-02T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-03T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-04T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-05T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-06T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-07T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-08T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-09T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-10T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-11T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-12T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-13T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-14T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-15T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-16T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-17T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-18T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-19T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-20T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-21T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-22T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-23T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-24T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-25T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-26T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-27T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-28T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-29T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-30T00:00:00\",\"y\":3108\},\{\"x\":\"2023-01-31T00:00:00\",\"y\":3108\},\{\"x\":\"2023-02-01T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-02T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-03T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-04T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-05T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-06T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-07T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-08T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-09T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-10T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-11T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-12T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-13T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-14T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-15T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-16T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-17T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-18T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-19T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-20T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-21T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-22T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-23T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-24T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-25T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-26T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-27T00:00:00\",\"y\":2981\},\{\"x\":\"2023-02-28T00:00:00\",\"y\":2981\},\{\"x\":\"2023-03-01T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-02T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-03T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-04T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-05T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-06T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-07T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-08T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-09T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-10T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-11T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-12T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-13T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-14T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-15T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-16T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-17T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-18T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-19T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-20T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-21T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-22T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-23T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-24T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-25T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-26T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-27T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-28T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-29T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-30T00:00:00\",\"y\":3749\},\{\"x\":\"2023-03-31T00:00:00\",\"y\":3749\},\{\"x\":\"2023-04-01T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-02T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-03T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-04T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-05T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-06T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-07T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-08T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-09T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-10T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-11T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-12T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-13T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-14T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-15T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-16T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-17T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-18T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-19T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-20T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-21T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-22T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-23T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-24T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-25T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-26T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-27T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-28T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-29T00:00:00\",\"y\":3974\},\{\"x\":\"2023-04-30T00:00:00\",\"y\":3974\},\{\"x\":\"2023-05-01T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-02T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-03T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-04T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-05T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-06T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-07T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-08T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-09T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-10T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-11T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-12T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-13T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-14T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-15T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-16T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-17T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-18T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-19T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-20T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-21T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-22T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-23T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-24T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-25T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-26T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-27T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-28T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-29T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-30T00:00:00\",\"y\":3274\},\{\"x\":\"2023-05-31T00:00:00\",\"y\":3274\},\{\"x\":\"2023-06-01T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-02T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-03T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-04T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-05T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-06T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-07T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-08T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-09T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-10T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-11T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-12T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-13T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-14T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-15T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-16T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-17T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-18T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-19T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-20T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-21T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-22T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-23T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-24T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-25T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-26T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-27T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-28T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-29T00:00:00\",\"y\":3880\},\{\"x\":\"2023-06-30T00:00:00\",\"y\":3880\},\{\"x\":\"2023-07-01T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-02T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-03T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-04T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-05T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-06T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-07T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-08T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-09T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-10T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-11T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-12T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-13T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-14T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-15T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-16T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-17T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-18T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-19T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-20T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-21T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-22T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-23T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-24T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-25T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-26T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-27T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-28T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-29T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-30T00:00:00\",\"y\":4166\},\{\"x\":\"2023-07-31T00:00:00\",\"y\":4166\},\{\"x\":\"2023-08-01T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-02T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-03T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-04T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-05T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-06T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-07T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-08T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-09T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-10T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-11T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-12T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-13T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-14T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-15T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-16T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-17T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-18T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-19T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-20T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-21T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-22T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-23T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-24T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-25T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-26T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-27T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-28T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-29T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-30T00:00:00\",\"y\":1654\},\{\"x\":\"2023-08-31T00:00:00\",\"y\":1654\},\{\"x\":\"2023-09-01T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-02T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-03T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-04T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-05T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-06T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-07T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-08T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-09T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-10T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-11T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-12T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-13T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-14T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-15T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-16T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-17T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-18T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-19T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-20T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-21T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-22T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-23T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-24T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-25T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-26T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-27T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-28T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-29T00:00:00\",\"y\":3209\},\{\"x\":\"2023-09-30T00:00:00\",\"y\":3209\},\{\"x\":\"2023-10-01T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-02T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-03T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-04T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-05T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-06T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-07T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-08T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-09T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-10T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-11T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-12T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-13T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-14T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-15T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-16T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-17T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-18T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-19T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-20T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-21T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-22T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-23T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-24T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-25T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-26T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-27T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-28T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-29T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-30T00:00:00\",\"y\":3851\},\{\"x\":\"2023-10-31T00:00:00\",\"y\":3851\},\{\"x\":\"2023-11-01T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-02T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-03T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-04T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-05T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-06T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-07T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-08T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-09T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-10T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-11T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-12T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-13T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-14T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-15T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-16T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-17T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-18T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-19T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-20T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-21T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-22T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-23T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-24T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-25T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-26T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-27T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-28T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-29T00:00:00\",\"y\":4506\},\{\"x\":\"2023-11-30T00:00:00\",\"y\":4506\},\{\"x\":\"2023-12-01T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-02T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-03T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-04T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-05T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-06T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-07T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-08T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-09T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-10T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-11T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-12T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-13T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-14T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-15T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-16T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-17T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-18T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-19T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-20T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-21T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-22T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-23T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-24T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-25T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-26T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-27T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-28T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-29T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-30T00:00:00\",\"y\":4539\},\{\"x\":\"2023-12-31T00:00:00\",\"y\":4539\}]\},\{\"type\":\"datatag\",\"name\":\"FC\",\"value\":\"local/datatable//plugins/servlet/epm//eigen-webtools-servlet/sqlquery?&cmd=EXECUTE&db=ecnor-db&query= with P as ( select DAYTIME as DAYTIME,SUM(NET_OIL_RATE) as FC from dv_PROD_FIELD_FORECAST FF where ff.DAYTIME between (select TRUNC (sysdate,\'YEAR\') from DUAL) and (select ADD_MONTHS(TRUNC (sysdate,\'YEAR\'),12) from DUAL) and ff.FORECAST_TYPE = \'MONTH\' and ff.SCENARIO = \'FORECAST\' and FF.EFFECTIVE_DAYTIME = (SELECT MAX(EFFECTIVE_DAYTIME) FROM dv_PROD_FIELD_FORECAST a WHERE a.OBJECT_CODE = FF.OBJECT_CODE) group by ff.DAYTIME ), Q as ( SELECT ((select TRUNC (sysdate,\'YEAR\') from DUAL) %2B (LEVEL -1)) AS DAYTIME, to_char(((select TRUNC (sysdate,\'YEAR\') from DUAL) %2B (LEVEL -1)),\'mm\') as MONTH FROM DUAL connect by level <=( (select ADD_MONTHS(TRUNC (sysdate,\'YEAR\'),12) from DUAL) - ((select TRUNC (sysdate,\'YEAR\') from DUAL))) ) SELECT concat(to_char(Q.DAYTIME,\'YYYY-MM-DD\'),\'T00:00:00\') as %22x%22, first_value(P.FC) over (partition by Q.MONTH order by Q.DAYTIME) as %22y%22 FROM Q left JOIN P ON Q.DAYTIME = P.DAYTIME order by Q.DAYTIME\",\"description\":\"\",\"metaData\":\{\},\"hidden\":false,\"status\":\{\"_params\":\{\"contexts\":\{\}\}\},\"units\":\"sm3\",\"enumerated\":null,\"replacements\":\{\"reporttime\":\"1673305199000\"\},\"localData\":[\{\"x\":\"2023-01-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-29T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-30T00:00:00\",\"y\":null\},\{\"x\":\"2023-01-31T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-02-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-29T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-30T00:00:00\",\"y\":null\},\{\"x\":\"2023-03-31T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-29T00:00:00\",\"y\":null\},\{\"x\":\"2023-04-30T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-29T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-30T00:00:00\",\"y\":null\},\{\"x\":\"2023-05-31T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-29T00:00:00\",\"y\":null\},\{\"x\":\"2023-06-30T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-29T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-30T00:00:00\",\"y\":null\},\{\"x\":\"2023-07-31T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-29T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-30T00:00:00\",\"y\":null\},\{\"x\":\"2023-08-31T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-29T00:00:00\",\"y\":null\},\{\"x\":\"2023-09-30T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-29T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-30T00:00:00\",\"y\":null\},\{\"x\":\"2023-10-31T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-29T00:00:00\",\"y\":null\},\{\"x\":\"2023-11-30T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-01T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-02T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-03T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-04T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-05T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-06T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-07T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-08T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-09T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-10T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-11T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-12T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-13T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-14T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-15T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-16T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-17T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-18T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-19T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-20T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-21T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-22T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-23T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-24T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-25T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-26T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-27T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-28T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-29T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-30T00:00:00\",\"y\":null\},\{\"x\":\"2023-12-31T00:00:00\",\"y\":null\}]\}],\"axes\":[\{\"side\":\"left\",\"num\":0,\"min\":\"auto\",\"max\":\"auto\",\"format\":\"auto\",\"step\":\"auto\",\"units\":\"sm3\",\"colour\":\"#84C661\",\"type\":\"step-before\",\"reference\":null,\"stacked\":true,\"style\":1,\"linestyle\":1,\"lineWidth\":\"1.5\",\"hideFuture\":1681081199000,\"groupType\":\"none\",\"groupFunctionType\":\"first\",\"maxLabelWidth\":80,\"meta\":\{\}\},\{\"side\":\"left\",\"num\":0,\"min\":\"auto\",\"max\":\"auto\",\"format\":\"auto\",\"step\":\"auto\",\"units\":\"sm3\",\"colour\":\"#42A4FF\",\"type\":\"step-before\",\"reference\":null,\"stacked\":true,\"style\":1,\"linestyle\":1,\"lineWidth\":\"1.5\",\"hideFuture\":1681081199000,\"groupType\":\"none\",\"groupFunctionType\":\"first\",\"maxLabelWidth\":80,\"meta\":\{\}\},\{\"side\":\"left\",\"num\":0,\"min\":\"auto\",\"max\":\"auto\",\"format\":\"auto\",\"step\":\"auto\",\"units\":\"sm3\",\"colour\":\"#BBC6C7\",\"type\":\"step-before\",\"reference\":null,\"stacked\":true,\"style\":1,\"linestyle\":1,\"lineWidth\":\"1.5\",\"hideFuture\":1681081199000,\"groupType\":\"none\",\"groupFunctionType\":\"first\",\"maxLabelWidth\":80,\"meta\":\{\}\},\{\"side\":\"left\",\"num\":0,\"min\":\"auto\",\"max\":\"auto\",\"format\":\"auto\",\"step\":\"auto\",\"units\":\"sm3\",\"colour\":\"#002F5C\",\"type\":\"step-after\",\"reference\":null,\"stacked\":false,\"style\":1,\"linestyle\":1,\"lineWidth\":\"1.5\",\"hideFuture\":false,\"groupType\":\"none\",\"groupFunctionType\":\"average\",\"maxLabelWidth\":80,\"meta\":\{\}\},\{\"side\":\"left\",\"num\":0,\"min\":\"auto\",\"max\":\"auto\",\"format\":\"auto\",\"step\":\"auto\",\"units\":\"sm3\",\"colour\":\"#840029\",\"type\":\"step-before\",\"reference\":null,\"stacked\":false,\"style\":1,\"linestyle\":1,\"lineWidth\":\"1.5\",\"hideFuture\":false,\"groupType\":\"none\",\"groupFunctionType\":\"average\",\"maxLabelWidth\":80,\"meta\":\{\}\}],\"modes\":[\{\"mode\":\"raw\"\},\{\"mode\":\"raw\"\},\{\"mode\":\"raw\"\},\{\"mode\":\"raw\"\},\{\"mode\":\"raw\"\}],\"bounds\":[1672527600000,1704063600000],\"boundsHistory\":[],\"live\":true,\"liveOffset\":\"\",\"liveSnapTo\":\"year\",\"refreshRate\":\"auto\",\"sync\":false,\"title\":\{\"main\":\"\",\"sub\":\"\",\"fgcolour\":\"#333333\",\"bgcolour\":\"#ffffff\",\"size\":\"24\",\"alignment\":\"center\"\},\"seamless\":true,\"locked\":true,\"tz\":\"Europe/Oslo\",\"ampm\":false,\"numPoints\":1000,\"useCache\":true,\"savedPoints\":[],\"type\":\"line\",\"allowExternalChanges\":false,\"scaleToFillHeight\":false,\"noLabelPrefixes\":false,\"enableTimeWindowShortcuts\":false,\"timeWindowShortcuts\":null,\"theme\":null,\"hideLegend\":false,\"hideYAxes\":false,\"hideXAxes\":false,\"isTimeBased\":true,\"invertAxes\":false,\"includeStats\":false,\"defaultMargin\":false\}],\"vars\":\{\"reporttime\":\{\"value\":\"1673305199000\"\}\},\"tags\":[\"dpr\"],\"promptIfDirtyClose\":true\}