I'm not entirely understanding how AssessedDate and IsPublished are reported in the Outcomes...
I'm not entirely understanding how AssessedDate and IsPublished are reported in the Outcomes Demonstrations data set. I managed to re-create the Mastery View using Magic ETL in Domo, but I had to do some extra steps to deal with nulls and unexpected data.
For example, for the following outcome, the Mastery View is showing Proficient and hidden for the test student when I look at the course in D2L, yet when sorting by latest assessed date, the level is Developing and IsPublished is null.
I was going to just use the latest assessed date to pull out the level from the data sets, but obviously that wouldn't work. (I got past this by replacing nulls and ordering on both IsPublished and AssessedDate using Rank & Window partitioned by student and outcome.) I just don't understand why that row exists if that change was not actually made or how IsPublished is null again.