hi Queue,
what if i add another condition for attendance calculation? say for example, in Attendance Table, i have another field called "Lesson" which could be maths lesson, literature lesson or music lesson. now i want to calculate the attendance percentage of a particular student for his music lessons. how can i do it?
sum(relation::present)/Count(relation::id) will only return percentage of all the lessons.
thanks in advance!