cooley-pe opened a new issue #12314: URL: https://github.com/apache/superset/issues/12314
**Is your feature request related to a problem? Please describe.** Rolling sums (and the like) don’t handle sparse dates in an intuitive way. For example if you have one data point per year for 10 years, but want a 365 day rolling sum (time grain: day, Periods: 10 is for illustration purposes, as a 365 day rolling sum would be Period: 10), it will count all 10 of those data points, even though they’re over the span of 10 years.   **Describe the solution you'd like** There should be an option (or it should be defaulted) to use calendar dates for the rolling calculation regardless of whether they appear in the data set. [Pandas rolling() function supports](https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.rolling.html) this by making the date the Index. **Describe alternatives you've considered** Make this the default and only functionality. I can't think of a time that the current behavior would be preferrable. ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
