This basic Tableau workbook provides a report that details the status of announcements within courses. The report is published to Tableau Online and the quality team uses this as part of pre-term checks. This is primarily used to confirm at least one announcement has been posted to upcoming term courses prior to the term start. Instructors are required to post a welcome announcement that contains relevant information (late policies, etc.).
Included in the report is a count of the number of announcements posted and the number of delayed post announcements. This can be the same number. A filter is available to narrow the data shown to only those that have or do not have an announcement posted.
|COUNTD(if [Type (Discussion Topic Dim)]= "Announcement" THEN [Id (Discussion Topic Dim)] |
|COUNT([Delayed Post At])|
|IF [# Announ] >=1 THEN "Has Announcement"|
ELSEIF [# Announ] = 0 THEN "No Announcement"
|"https:// xyz.instructure.com/courses/"+STR([Canvas Id (Course Dim)])+"/announcements"|