AnsweredAssumed Answered

Conversation Response

Question asked by Alan Kinsey on Oct 30, 2017

Ok. We are working with Canvas data and really building it from the ground up with our databases and what queries we want to run. We are currently looking to see how to find the response time for an instructor to respond to student messages. So end goal: an average response time for an instructor to respond to a student's message.

 

We know we are working within these tables:

communication_channel_dim
communication_channel_fact

conversation_dim
conversation_message_dim
conversation_message_participant_fact

 

Has anyone else already worked through these queries and where to build the information? 

Thanks in advance!

Outcomes