Using the CASE function in DataStudio to generate factors
The college has six campuses with each campus in its own subaccount in the LMS. Attempts to build a dashboard that would output current score data by subaccount ran into the difficulty that the Grade Report CSV export does not provide information on the source subaccount for courses. The only column with data from which the subaccount information is a section column. The section code suffixes indicate the campus on which the course is taught, and campuses are subaccounts. Thus the goal is to assign subaccounts (campuses) to courses. Here the campuses are effectively a data analysis factor. A first attempt was to go after the low hanging fruit of setting up a control to display online or residential courses. All Online courses are in their own subaccount. Online courses have a section designation of /On where n is a single digit integer. At present there are no courses with more than nine sections in a subaccount. The CONTAINS_TEXT function looks for the /O in the section nam...