Works! thank yu!!!!
Unfortunately I cannot share a sample .xml because it contains too much personal data that I am not able to share, and recreating this would be challe...
Yes - that is the result I wanted, but requires more queries than I anticipated. I think I will stick with my old method of creating the countIF in m...
Thank you - this works - however, it is important to be able to see which of the segments (1-12) the student received an E or P in, and a count of eac...
I am having trouble with this new process as well. When I try to create a query "from Folder" my data is truncated at about 434 records when there sh...
Each row in my example represents a single student and the columns represent which "weeks or segments" of a class they completed. So not only do we w...
Thank you - I may be able to use that query for part 1 of my data cleanup. Then rejoin it to the remaining data being student entries shown below the...