Help with Data/Table Summarizing into New Collection
I'm trying to take an existing collection of student records with scores and summarize the data into a new collection. The existing records look something like this:
And I'm trying to summarize it by:
Get my my Distinct Date values, then
Get my Distinct StudentName values for each date, so I can
Get the Average score for each Student, for each Date
So in the end, I have a new table like this:
I've been able to put together a Distinct table for Date or StudentName and add the average score with AddColumns, but I can't figure out how to get all three columns organized and working together. I keep getting "[object Object], [object Object]" values and I'd like to avoid GroupBy because the resulting collection needs to feed into a Line Chart.
I'm stumped. Any help pointing me in the right direction is appreciated.