README.md

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

Overview

This R package contains a series of functions used to achieve a horizontal-oriented data reporting view

Installation

devtools::install_github("pkopps/biview")

Usage

library(biview)

fun(
  df = performance,
  metric = revenue,
  grouping = wk_num_in_yr
)
# # A tibble: 5 x 5
#   metric         `w23|03-Jun` `w24|10-Jun` `w25|17-Jun` `w26|24-Jun`
#   <chr>          <chr>        <chr>        <chr>        <chr>       
# 1 metric_cur_yr  3495997.57   3522205.21   3503224.4    2990343.11  
# 2 metric_prev_yr 3503042.46   3497006.25   3501900.98   3500468.76  
# 3 prev_yr_var    -0.2%        0.72%        0.04%        -14.57%     
# 4 metric_goal    NA           NA           NA           NA          
# 5 goal_var       NA           NA           NA           NA

Combine with other packages like dplyr and formattable to add more flexibility

library(biview)
library(dplyr)
library(formattable)

performance %>% 
  filter(company_name == 'Dunder Mifflin', salesman_full_name == 'Dwight Schrute') %>% 
  fun(
    df = .,
    metric = revenue,
    grouping = wk_num_in_yr
  ) %>% 
  formattable()

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