Moving Average Report Creation Help

[Coolavin]

Hello,

I am looking for help creating a moving averages report in Qlik Sense.

I have tried several things. The expression below is what seems to be the closest, but it still doesn't seem right. 

=Avg(Aggr(RangeAvg(above(ExamScore,0,30)), ExamDate, 1))

Below is what the report should look like:

The two data points are:

1. The number of exams taken
2. The average score of the exam

Thank you for your help.

[Kushal_Chawda]

@Coolavin  could you share sample data with expected output?

[Coolavin]

Here is an example of the data:

ExamID	ExamScore	ExamDate
4006	92	8/3/2021
3205	78	8/6/2021
7732	80	8/4/2021
1132	85	8/9/2021
2289	80	8/10/2021
4893	86	8/5/2021
4800	88	8/6/2021
6901	90	8/7/2021
2300	81	8/14/2021
2321	83	8/10/2021
3233	82	8/3/2021
3211	90	8/3/2021
4322	80	8/10/2021
4532	85	8/9/2021
5323	87	8/4/2021

I don't have an expected output because I can't get it to work but it should look something like this:

 

[Kushal_Chawda]

@Coolavin  look at  below

https://community.qlik.com/t5/QlikView-Documents/Bollinger-Bands/ta-p/1493596

[Coolavin]

that's a nice looking chart. I am just not seeing how you do that in qlik sense. Any ideas?