Comparing tables for differences

[StephenLis]

Hi All

Newbie here thinking that I may have bitten off more than I can chew.

Trying to get a better view of data from our student information system at my school.

Each student is required to complete 5 outcomes for each subject. This report is designed to show teachers which students have or have not completed the required 5 outcomes.

On the page below the Outcomes visualisation shows me how many outcomes each student has completed for whatever subject or class is selected in the slicer, and I can see who has not done the required 5. This comes from the outcomes table. So far so easy.

The student information system only adds a row to the outcomes table each time an outcome is completed. This means I am unable to see any student who has completed zero outcomes from this table.

The full class list is from another table (well two tables with a relationship if that makes a difference, student ID from an enrolment table and name from the user table). This shows me all the students in a class.

I would really like to be able to generate a list of students who are present in the Full class list visual but not in the outcomes, in other words, who has not completed any outcomes.

The outcomes table contains about 250,000 rows as it potentially has 5 outcomes for every student for every term for every subject. So a student may have completed outcomes for another subject and therefore be present in the outcomes table but not for the class I am viewing.

I have been trying to find a solution to this for a few days now without success. I have found a few similar requests but have not been able to get them to work in this scenario.

Thanks in advance for any help.

Cheers

Stephen (the frustrated teacher)

[Anonymous]

Hi  @StephenLis ,

Do you mean to generate a list of incompleted students? How do you determine completed and incompleted? Can you share your formula?

If it is convenient, can you create a sample data, delete sensitive data, and display the results you want in the form of pictures.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.