This idea is being reposted from an idea that was closed and archived to Cold Storage. It had 22 votes and was created on April 17, 2018. CanvasData: Add total_activitity_time to enrollment_dim
The total_activity_time data for an enrollment is currently available only in the API. Please make this piece of data available in enrollment_dim just like the last_activity_at date is.
I've had to write a script to populate a separate database table from api calls to each enrollment, which is very time-consuming and difficult to keep up to date since it takes so long to update.
We use this piece of data to determine instructors with zero or limited participation in their courses.