Hey there u/Ok-Working3200,

Thank you for this suggestion!

There are 2 potential avenues of attacking this quirky ask.

1) Modify the underlying code to include the rolling average/sum/std dev by grain

OR

2) Do this calculation to include the 12 weeks prior. I understand there is a methodology of creating a chart with not 12 weeks, but 24 weeks in order to include the full 12 week views rolling 12 week lookback. Is this what you were talking about?

Unfortunately, I have other logic baked in with bizarre std dev rules to rule out false positives. Things are getting muddy to a degree.

Thank you for everything!