Data counts don't seem to be all showing up in a line graph.

[Coolavin]

I am having an issue with all of the data showing up.

In the image below the top graph for moving averages has a total of 14.47k exam while the graph under it shows a total count of 42,986. 

Shouldn't the total at the end of the moving averages graph be the same or close to the total of the count?

For the moving averages I am using this expression:

=Aggr( Count( ExamID),ExamAchievedDate)

For the totals I am using this expression(all of the ExamIDs  do have ExamAchievedDate):

=count(distinct ExamID) 

I would think that the distinct count would be the smaller count. Is there something, that could be limiting the top graph or is there a different/better way to get the counts for the bottom of the moving averages graph?

 

 

[vinieme12]

What is your expression for NumberofExams?

How is this moving average?? this is just a count of ExamID for each date row

=Aggr( Count( ExamID),ExamAchievedDate)

[vinieme12]

Please post a sample if possible

[Coolavin]

For the moving average I forgot to include the measure. Below is the Dimension and the measure for the moving average.

The Dimension is:

=Aggr( Count( ExamID),ExamAchievedDate)

The measure is:

=aggr(RangeAvg(Below(avg(ExamScore),0,50)),ExamAchievedDate)