I need to create a moving averages report in Qlik Sense that uses a line chart and looks some what like the image below.
There are two data points: "Exam scores" and "attempts".
Within a selectable time period for the first 1-30 attempts it finds the average and plots it on the graph.
Then for the next one it should find the average for 2-31 and plot it on the graph
and then for 3-32 and so on to the last exam score.
Is this something that is dynamically possible? Would you use the RangeAvg function? If so, how would you do it? If not what would you use? Thank you for your help.