I have a db with scores (various performance characteristics of job functions)that are collected several times per month and then summed or averaged based on our needs. I would like to compare the data side-by-side and month-to-month to measure changes over time. I have queries that pull the scores together by sum by month, that provide average scores by individual or by team, but would like to pull the data into a query (for reporting and graphing, if possible) that shows the data side-by side and shows the change in scores as the individual moves through time. Basocally, a progress report. My goal is to have a 3-month comparison that ties together with some programs we have in place that are being tracked to see if we are making progress. I see lots of questions regarding data by date - but could not locate anything that would show the changes over time in one query. Essentially, I would like to see the data for 3 mnonths (February, March, and April,e.g.) in one view for each of the characteristics being scored for an individual, with the amount of change (+ or -). I hope this is clear enough to help get some input. Thanks.
Comparison of data month to month
- Thread starter cft
- Start date
