View Pivot Table R Steps Unavailable

Issues
#1

Hi - do you know why I can’t see the “export steps as R script option” for a pivot table? I’m using Exploratory Desktop v6.1.2.3

Thanks!

image
image.png1060×570 55.7 KB

#2

Hi @Bruce_T

You can only use “export steps as R script” in “Summary view” and “table view”. Therefore, it does not work in “Analytics view” or “Chart view”.

If you want to export the “Pivot table” as “R script”, you need to reproduce it in “table view” and use “export steps as R script” as shown below.

14
スクリーンショット 2020-09-22 9.56.14.png1614×893 156 KB 

# Steps to produce the output
exploratory::read_excel_file( "... /committed_data/Sample_Superstore.xls", sheet = "Orders", na = c('','NA'), skip=0, col_names=TRUE, trim_ws=TRUE, tzone='Asia/Tokyo') %>%
  readr::type_convert() %>%
  exploratory::clean_data_frame() %>%
  summarize_group(group_cols = c(`Category` = "Category", `Sub-Category` = "Sub-Category"),group_funs = c("none", "none"),Sales_sum = sum(Sales, na.rm = TRUE))
1 Like