Hello,
I have been struggling with this for days and decided to reach out for help.
I need to get both the total and the percentage of students who met 70% of their math subtests (there are other school subjects in this data set but just trying to keep it simple for the example. I need to see it by "Test" not subtest). Thank you to anyone who may be able to help.
Here is dummy data:
| User ID | Result | Test | Subtest |
| 1 | Met | Math | Fractions |
| 1 | Met | Math | Decimals |
| 1 | Met | Math | Equations |
| 1 | Not Met | Math | Word Problems |
| 1 | Not Met | Math | Statistics |
| 2 | Met | Math | Fractions |
| 2 | Met | Math | Decimals |
| 3 | Met | Math | Fractions |
| 3 | Met | Math | Decimals |
| 4 | Met | Math | Fractions |
| 4 | Met | Math | Decimals |
| 5 | Met | Math | Fractions |
| 5 | Not Met | Math | Decimals |
| 6 | Met | Math | Fractions |
| 6 | Not Met | Math | Decimals |
| 7 | Met | Math | Fractions |
| 7 | Met | Math | Decimals |
| 7 | Met | Math | Equations |
| 7 | Met | Math | Word Problems |
| 7 | Met | Math | Statistics |
| 8 | Met | Math | Fractions |
| 8 | Met | Math | Decimals |
| 9 | Met | Math | Fractions |
| 9 | Not Met | Math | Decimals |
| 10 | Met | Math | Fractions |
| 10 | Met | Math | Decimals |
| 11 | Met | Math | Fractions |
| 11 | Met | Math | Decimals |
| 12 | Met | Math | Fractions |
| 12 | Not Met | Math | Decimals |
