make_retention_sql will generate the standard SQL query for pulling retention data from Edify. This function helps in retrieving data related to student retention metrics. To specify the type of retention data you would like, use the type parameter.

make_retention_sql will generate the standard SQL query for pulling retention data from Edify. This function helps in retrieving data related to student retention metrics. To specify the type of retention data you would like, use the type parameter.

Usage

make_retention_sql(name, type = "term_to_term")

Arguments

name

The name you want the SQL file to have in your sql folder. This is a string and must be provided in quotes (e.g., "your_filename.sql").

type

The type of retention file you want. Defaults to 'term_to_term'.

The type parameter should be term_to_term cohort

Value

A sql file in your SQL folder