topic Re: Students with missing data request in App Development

Students with missing data request

sshastry — Thu, 01 Apr 2021 13:46:08 GMT

Thanking this group in advance for helping.

I work with a school system. We have data related to students. Students are enrolled in a school in the current year - they are considered active students. Each of those will request courses for next school year - we call this schedule_request. The process of requesting courses takes month, but during the process we would want to identify those students who has not completed specific requests.

For eg. all 5th grade students should have a request for Math course. Under the Math Department, there could be multiple math courses that they can pick from.
In my dataset, I have listed all active students with their grade level in table 1
I have another table which lists all the courses they have requested as table2

The question I am supposed to answer is :find out all the students who has NOT selected any courses from MATH department who are in 5th grade.

I created a table object which only lists current active 5th grade students.
I have a filter pane which lists departments.

I was trying to use the GetSelectedFields(DEPTNAME) as follows, but the table is not listing any students. I have used similar concept to get counts of students who does not have a specific courses -- but when it comes to a list of students in a table, I am unable to create it.

Only( { <DEPTDESCRIPTION=-{"$(=GetFieldSelections(DEPTDESCRIPTION))"}>} distinct SIS_NUMBER)

Thank you for your help

Re: Students with missing data request

Anil_Babu_Samineni — Fri, 29 Jan 2021 19:26:16 GMT

Instead you can try with concat() like

Only( { <DEPTDESCRIPTION-={"$(=Concat(DISTINCT Chr(39) & DEPTDESCRIPTION & Chr(39), ','))"}>} distinct SIS_NUMBER)

Re: Students with missing data request

sshastry — Fri, 29 Jan 2021 20:49:59 GMT

Thank you Anil, but it is not doing anything different to the list. Currently my table shows no data and changing it to this did not help. Also my users will select the department value from the filters so I had to use the GetFieldSelections to find out what they have selected and find the students who does not have that department in their record..

Re: Students with missing data request

Anil_Babu_Samineni — Fri, 29 Jan 2021 21:02:41 GMT

Will you be able to share sample data set to check once?

Re: Students with missing data request

sonkumamon — Fri, 29 Jan 2021 21:19:20 GMT

I would suggest you to solve in in the script level. Join the 2 tables to create a flag IsMathStudent. Something like this:

Table1:

Load * From ...

Left Join

Load

Student_ID,

1 as IsMathStudent

From....

Then on the expression:

Count( { <IsMathStudent -={1}>} distinct SIS_NUMBER)

Re: Students with missing data request

sshastry — Fri, 29 Jan 2021 21:26:23 GMT

Anil - I will try and get a small subset of data to load here. Still new to doing this so it will take me a day or so - Thank you