cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Jeff_F
Community Champion

Canvas Data 2 - Dataset Field suggestions

Jump to solution

Hello - I've received three requests to report on faculty use of media comments as submission feedback. As we are aware, CD1 does not have data points for media comments.  Upon review of the upcoming CD2 schema, I see submission_comments columns for media_comment_id and media_comment_type but no additional metadata about media is listed.  And so I'd like to suggest a field for media duration in format such as hh:mm:ss .  This will enable better reporting on how media is used.

The CD2 schema - 
https://docs.google.com/spreadsheets/d/1axjhLwPY4N16SAf61-X8xj3kSg_Ey-PXvcsUTtojRoo/edit#gid=1473158...

 

What additional data fields would be helpful?

 

1 Solution

Accepted Solutions
stimme
Community Contributor

Hey Jeff, Sorry if this is old news, but the CD1 submission_comment_dim table does have comment = "This is a media comment." for media comment records. This might be useful for your report in the short term. - Sam

View solution in original post

0 Kudos
2 Replies
stimme
Community Contributor

Hey Jeff, Sorry if this is old news, but the CD1 submission_comment_dim table does have comment = "This is a media comment." for media comment records. This might be useful for your report in the short term. - Sam

View solution in original post

0 Kudos
Jeff_F
Community Champion

@stimme  Yes, this does work -

IF CONTAINS([Comment], "This is a media comment") THEN 'Has Media'
ELSE "-"
END

The CD1 schema should probably note this in the description.  ;o)   https://portal.inshosteddata.com/docs#submission_comment_dim 

 

Additional data points for media would be useful.