Hi there,

I got a situation where I want to calculate the moving average.

All the existing moving average functionality looks like this :

MOVING_AVERAGE(MEAN(“field”), N ) … GROUP BY time(interval)

Where N is the number of points before the current calculated number to include in the calculation of the moving average.

But what I want to calculate is the moving average on a certain time of the day during the week.

So for example: MOVING_AVERAGE(MEAN(“field”) , N , P ) … GROUP BY time(interval)

Where N is the same as above

But P is the period between those points.

For example P = 1w , to calculate the moving average based on averages on the same timebucket N weeks before. ( For example timebucket : Monday 10:00-10:30)

Does somebody knows how to fix this with querying Influx?