Page Comparison

...

The chart based on this object would look like this:

And create the object with Cumulative selected ( I also name the object to make it clear)

I’ve used course – rather than dates because my data is a bit rubbish

Now split that by other dimensions

This will all work with your progression table (the snapshot in time). You can add the date dimension link to it, then select a date.

...

To show which step followed which step sequentially – we’d need to create a view.

. You can find the ‘View’ script at the bottom of this page. This would group the data in the progression table by student, show this min max date for each step.  Constructed as a union query.  Then , we can then calculate the days between each step.

This would be much simpler to build with you, probably a couple of hours work.

I have include the view script in this message as it also allows us to select date ranges nicely.

I Add date short name

...

We added date short name and then joined the date using a between

Now I can use this a  category object

...

We could now use this as a ‘Category Object’

...

which would allow us to select any of these dates in the dashboard

...

...