I understand previous posts regarding Moving Averages are available, but I cannot seem to find the solution to my problem through those posts (perhaps it's due to my lack of understanding, please en-light me in that case).
Basically, I have a set of data with my scores on previous practice exams. So each exam has a unique ID, each exam has 3sections (A,B,C), and my scores on each section, and each section has a unique completion date (I do one section per day, i.e., takes 3 days to complete one exam), I also attached an average to each exam at the raw data. In short, the raw data will have 4 rows per exam (A,B,C, avg), and each row has a exam ID, sub-section name (for the avg row, sub section name is called avg), score of sub section, completion date. (If you are curious, these are my scores for my LSAT practice exams).
Now my QlikView line chart's dimension is Exam ID (sorted by completion date). I have 4 expressions, each expression gives the score of a sub section (4th expression is the avg score), so the expression is: = avg({<Sections = {A}>}[Scale Score]).
I would like to further my analysis by looking at the moving average of my scores, so instead of seeing the trend of my scores per section per exam over time, I can also see if I have increase the average over time. But I'm stuck!
