Man pages for southwick-associates/salic
Prepare Agency Dashboard Data

calc_churnInternal Function: Calculate churn for a single year
check_dupsCheck for duplicates in a table
check_thresholdInternal Function: Perform an action (e.g., warning, error)...
count_lines_textfileCount rows in a text file
custSample Standardized Data: 30,000 Customers
dashboardSample Data: Metrics formatted for Dashboard Input
data_checkCheck standardized data (cust, lic, sale) formatting rules
data_check_tableCheck formatting rules for standardized data tables
data_foreign_keyCheck key coverage between two tables
data_internalInternal Functions: Individual Data Checks
data_salicSalic Sample Data Overview
df_factor_varConvert numeric to factor in data frame and check
est_churnEstimate churn by year from license history
est_partEstimate participants by year from license history
factor_varConvert numeric variable to factor
format_numInternal Function: Format numbers for printing
format_resultFormat estimated metrics for input to Dashboard
historySample Data: License History
history_checkChecking license history
history_internalInternal Functions: Making license history
label_categoriesConvert multiple numeric variables to factors
licSample Standardized Data: License Types
make_historyMake license history table
metricsSample Data: Dashboard Metrics
pct_roundInternal Function: Round numeric values and print as percent
prep_yrsInternal Function: Check years range & sort
print_datInternal Function: Print a data frame with caption/note
rank_saleFilter sales to 1 row per customer per year.
recode_agecatCreate age category based on year (of sale) and birth year
recode_monthStandardize month (for individual state dashboards)
recode_stateRecode state abbreviations
saleSample Standardized Data: Sales 2008 thru 2018
salicsalic: Prepare Agency Dashboard Data
scaleup_partScale segmented participation counts to total (if needed)
state_abbreviationsData: State/Province/Territory Abbreviations for US & Canada
summary_churnSummarize churn by year
summary_initialSummarize sales, customers, and churn by year
summary_saleSummarize sales and customers by year
variable_allowed_valuesInternal Function: Check allowed values for a single variable
southwick-associates/salic documentation built on Nov. 5, 2019, 9:13 a.m.