In the recently closed feature request https://github.com/getredash/redash/issues/3009, some of the dynamic tags suggested were not implemented, and as hosted service users at our company, additional 14, 30, and 60 day dynamic settings would be useful.
Is there a reason we only have a last 7 days option implemented, how about I make a pull request to add options to select the last 14, 30, and 60 days?
Thanks for taking a step at this, implementation looks good. The reason for not having more options is that I thought they belonged to a second part of this feature, basically a more general implementation that has an open discussion in this topic. Feel welcome to share your ideas in there too.
We had to revert this deployment because of an unrelated issue with the Snowflake query runner. Also there is an issue with GitHub that delays builds, so it might be back later today or tomorrow.
@arikfr Just a thought but I think that a 28 day look back makes more sense than 30 days. In particular because we already have 7 days and you’re adding 14.
The reason I think 28 days is much better that 30 days from a reporting point of view is that I imagine that everyone will be reporting on trends that have variations across the days of the week (weekend peaks for example). If you’re looking at a dashboard on Monday (probably peak time for dashboard consumption across the company) using 30 day look back, you’re going to be looking at a time range that contains 5 weekends which would skew the results; especially if you check again on Tuesday.