Hello,
In my use case, I have a table of data in which I am counting the number of student IDs per school in selected grades to see the participation per school in a given week.
The filters applied on the table are of “week” and “grade”.
I need to be able to calculate the percentage of active students in a school out of the total students registered in the school since the beginning of the academic year.
For this I need to be able to create a calculated field that avoids the date filter but abides by the grade filter, to count the total number of students in the school for the selected grades.
Is there a way to do this or some other solution to give me the required percentage calculation?