Hi, has Mynda ever recorded / published a video explaining how to deliver cohort analysis through BI?   

We are struggling to achieve this with our student assessment results, whereby we need to analyse how the student cohort group (Year Group) have done over the previous 3 years for the core subjects.  

Each academic year is split into 4 quarters, and it's the results from each quarter that we would compare over the previous 3 years.

We have included a date field for each record in the result set in case cohort analysis needs time/date field.

So example summary, the results for students in Year 6 for this academic year(22-23) in Q3, need to be compared to Year 5 results in academic year (21-22) in Q3, and Year 4 in academic year (20-21) in Q3.

The videos are extremely useful to newbies but i've been unable to find one.  Would be extremely grateful for video or assistance with the above.

Many thanks, 

James