Tags for day interval
How to calculate moving sums within variable size windows?
Hi! I am trying to calculate moving sums and row counts in a query, to do further arithmetic on the said values. For a range of 3 days, for example, I would sum the values given in the rows for those 3 days, and then divide them by the amount of rows in that same time period. In Oracle, the syntax would be:
olap window range_n between day interval interval