compare the difference in of field values

Question

How to calculate % of students with 4(sample) grade wrt all students who got same grade in all other departments?

How to show the % of each grade for all students from different grades?

Answer 1

Hi Anitha,

1. Add the class in row shelf.

2. Add the grade in column shelf.

3. Add the Students in text shelf and use count aggregation. Now add quick calculation -> % of total and select across the table.

4. You can now find % of students for grade against each class and compare them.

Hope it helps you.