# looker_to_ggplot - Tracks vs Albums - 01 Read and Clearn.r

## WHAT IS THIS? 
# https://theorchard.looker.com/x/fZDd9kp


.us()
setScience(projName="Looker", subl=FALSE, quiet=TRUE, load=FALSE)


f.in <- "~/gitData/orch/data/Looker/2 Tracks vs Albums ---  Genre  Continent  Month  Country Unpivotted.csv"
MainTitle <- "iTunes Revenue comparing Albums vs Tracks\n Oct 2013 through Jan 2014\n"
ratioCol <- "Audio_or_Video"
ratioCol <- "Album_or_Track"
valueCol <- "Total_Gross_Revenue"

rowsToExclude <- list(Genre=c("Video", "DVD"))

## Number of countries to include per Continent Group
TopN <- 6L

## hierarchies, for now, is getting loaded in with supportFns

Tracks_vs_Albums.output <- lookerToBarChart(f.in=f.in, ratioCol=ratioCol, valueCol=valueCol, rowsToExclude=rowsToExclude, MainTitle=MainTitle, hierarchies=hierarchies, TopN=TopN, verbose=verbose)