Skip to main content
Expert ⭐️⭐️⭐️⭐️
April 21, 2022
Solved

Charts: Help with 12 month BTU Rolling Average - says too long time frame

  • April 21, 2022
  • 11 replies
  • 317 views

 

Hello  @brendan Buckbee at Celanese has created a chart for the 12 month, but gets an error message. Is there any way that this can be created into a chart. I have attached a screenshot of the calcs. 

cc: @Kylie R 

 

Best answer by Simon Funke

I understand.

Keep also in mind that the moving average function (as it is implemented today) computes the pointwise average in each window, e.g.

(sum_x f(x)) / N,

where N is the number of data points x with values f(x) in the window - and not the integral average, i.e.

(integral t0..t1 f(x)) / (t1 - t0),

where t0 and t1 are the start and endtime of the window.

Is it the pointwise average that you are looking for?

 

Regarding your question on automatic resampling: with automatic resampling, data points of two or more time series are automatically aligned to a common timestamps if needed (by interpolation). The simplest example is adding two time series with non-matching timestamps. Without automatic reindexing the sum output will be empty (because none of the timestamps match), while with automatic reindexing, the sum output will have a value at the timestamps of both inputs. 

 

Finally: I am working on reducing the amount of downsampling that we do by a significant amount (hopefully 10x). We are currently testing the robustness of the solution, but if things go well we can roll this out in the next 1-2 weeks.

11 replies

Simon  Funke
Practitioner ⭐️⭐️⭐️
Practitioner ⭐️⭐️⭐️
June 16, 2022

Quick update: we have now removed downsampling for time series with less than 100K data points (before 10K).