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!