wmy_3e: [w]eek [m]onth [y]ear _ [3] [e]xports

In pkopps/biview: Functions to Achieve Classic GBI Report Format (Four Weeks, All Months, Run Rate, YTD, Previous Year Variance, etc.)

Description

[w]eek [m]onth [y]ear _ [3] [e]xports

Usage

wmy_3e(df_wk, df_mth, df_yr, metric, df_rr, metric_rr, df_goal, metric_goal,
  df_3p9, metric_3p9, df_6p6, metric_6p6, df_9p3, metric_9p3,
  week_end_dates = FALSE, week_start_dates = TRUE, full_yr = TRUE,
  cbr_ytd = TRUE, rate = FALSE, new_name = NULL, commas = FALSE,
  neg_var_paren = TRUE, div_by_1000 = FALSE, prefix = "", suffix = "",
  scalar = 1, digitsAfterDecimal = 2, spark = FALSE, pop = FALSE,
  pop_threshold = 100, in_mth_header_op2 = TRUE,
  in_mth_header_3p9 = FALSE, in_mth_header_6p6 = FALSE,
  in_mth_header_9p3 = FALSE)

Arguments

df_wk	weekly grain data frame
df_mth	monthly grain data frame
df_yr	yearly grain data frame
metric	column name for metric (uniform across all the grains of data frames)
df_rr	data frame containing run rate
metric_rr	column name from df_rr
df_goal	data frame containing goal
metric_goal	column name from df_goal
df_3p9	data frame containing 3 plus 9
metric_3p9	column name from df_3p9
df_6p6	data frame containing 6 plus 6
metric_6p6	column name from df_6p6
df_9p3	data frame containing 9 plus 3
metric_9p3	column name from df_9p3
week_end_dates	logical. display week end dates in week portion header
week_start_dates	logical. display week start dates in week portion header
full_yr	logical. Inlcude full year summation column for month view
cbr_ytd	logical. Inlcude YTD definition for CBR : Actual values from last completed month
rate	logical. Adjust logic to handle full year for rates
new_name	name for metric output. Also creates new labels for previous year, previous year variance, etc.
commas	format values with commas. ie: 1234000 -> 1,234,000
neg_var_paren	format variance values with parenthesis. ie: -40.4 -> (40.4)
div_by_1000	also an accounting practice; divide all value by 1000. ie: 1234000 -> 1234.00
prefix	add prefix to values. ie: 2000 -> $2000
suffix	add suffix to values. ie: 20.54 -> 20.54%
in_mth_header_9p3

pkopps/biview documentation built on May 22, 2019, 2:48 p.m.