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

Description Usage Arguments

Description

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

Usage

1
2
3
4
5
6
7
8
9
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.