Skip to contents

MDB Munging

collapse_base_tbl()
Collapse base MSD down to a desired level for main MDB table
collapse_vlc_tbl()
Collapse base MSD down to a desired level for core treatment indicators
make_mdb_df()
Create a base table of MDB indicators stacked long
make_mdb_tx_df()
Creates the base table for the treatment / VLS MDB tables
reshape_mdb_df()
Prepare filtered data frame for MSD briefer formatting
reshape_mdb_tx_df()
Prepare filtered data frame of treatment indicators for MDB formatting

Table Creation

create_mdb()
Wrapper function to create a MDB table
mdb_main_theme()
GT theme for main MDB tables
mdb_treatment_theme()
GT theme for main MDB tables

Helper functions

bold_column()
Bold columns inside gt objects Helper function to quickly make columns within table bold
bold_rowgroup()
Make all text larger Bold Agency names - used to increase stroke on row group label
calc_growth()
Calculate growth between two metrics that are positive
create_pd()
Return msd metadata for pd object
embiggen()
Embiggen parts of mdb table A noble spirit embiggens the smallest man
fetch_indicators()
Fetches indicators used to make tables, accounting for quarter of MSD and semi-annual indicators
format_indicator()
Formats PEPFAR indicators for MDB tables
label_aggregation()
Label aggregation level
make_achv_shape()
Generate colored circle as an svg
make_chg_shape()
Create fontawesome performance arrow
msd_period()
Identify MSD Period and Type
extract_num_colnames()
Extract a vector of numeric column names
legend_q1
Object pointing to github location of legend for Q1
legend_q2
Object pointing to github location of legend for Q2
legend_q3
Object pointing to github location of legend for Q3
legend_snapshot
Object pointing to github location of legend for snapshot indicators and Q4