Comparing assessment scores
I'm trying to create a report that looks at a range of dates, and takes the score from the first assessment and compares it to the score in the most recent assessment. I then need to chart the difference over time.
To make things more complicated, the first assessment only counts when the score is > 9.
Has anyone created a report like this, or have any input?
I've tried using rownum and subqueries - the frustrating part about the subqueries is that you can't reference data between subqueries except with Advanced Function, which has its limits.