Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
Please post a sample if possible
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)