Running Average

[NoSpatula]

I need to produce a running average. Basically a 30/60/90 day average of scores for participants. Not sure how to do this.



Each month contains a snapshot of the quality score (which is derived using an expression) for an individual. 'tenuremonth' is the month captured. How would tally the average for the first 2 months? 3 months?

I'm not an experienced SQL'er (more of a SOL'er) =). I'm hoping it can be done through the query grid. Expressions even.





Thanks!

[ranman256]

make 3 queries, 1 for each N-day range and compute the AVG
then in Q4, add in all 3 avg qrys to the data query.