Average Across Related Records

[merlyn383]

I have a table that contains records of stdent performance in several different classes across several different terms. I have a self-join relationship setup where:

TermCode = TermCode

Course = Course

TotalAvg x TotalAvg

If I define a field ClassAvg to be a calculation "Average ( Self-JoinTable::TotalAvg )" shouldn't this relationship allow me to see the average of all sudents in the same course in the same term as the record that I am currently viewing? Also, couldn't I define a similar field to get the standard deviation of the TotalAvg within the same course/term? Or am I just missing something fundamentaly wrong with my relationship?

[merlyn383]

I have a table that contains records of stdent performance in several different classes across several different terms. I have a self-join relationship setup where:

TermCode = TermCode

Course = Course

TotalAvg x TotalAvg

If I define a field ClassAvg to be a calculation "Average ( Self-JoinTable::TotalAvg )" shouldn't this relationship allow me to see the average of all sudents in the same course in the same term as the record that I am currently viewing? Also, couldn't I define a similar field to get the standard deviation of the TotalAvg within the same course/term? Or am I just missing something fundamentaly wrong with my relationship?

[merlyn383]

I have a table that contains records of stdent performance in several different classes across several different terms. I have a self-join relationship setup where:

TermCode = TermCode

Course = Course

TotalAvg x TotalAvg

If I define a field ClassAvg to be a calculation "Average ( Self-JoinTable::TotalAvg )" shouldn't this relationship allow me to see the average of all sudents in the same course in the same term as the record that I am currently viewing? Also, couldn't I define a similar field to get the standard deviation of the TotalAvg within the same course/term? Or am I just missing something fundamentaly wrong with my relationship?

[Ugo DI LUCA]

Hi,

I would think the "X" relationship condition isn't necessary here, but I may not have fully understood your question and settings.

[Ugo DI LUCA]

Hi,

I would think the "X" relationship condition isn't necessary here, but I may not have fully understood your question and settings.

[Ugo DI LUCA]

Hi,

I would think the "X" relationship condition isn't necessary here, but I may not have fully understood your question and settings.

[comment]

Yes, the X criterion doesn't seem to do anything.

Regarding your calc, I think you want Average ( Self-JoinTable::Grade ).

[comment]

Yes, the X criterion doesn't seem to do anything.

Regarding your calc, I think you want Average ( Self-JoinTable::Grade ).

[comment]

Yes, the X criterion doesn't seem to do anything.

Regarding your calc, I think you want Average ( Self-JoinTable::Grade ).