Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I have created two R scripts script1 and script2
script1 saves the dataframe using saveRDS function into a local directory
script2 reads the saved dataframe and displays the data.
The problem is that script1 reacts to a selection I make via a "slicer" dropdown but script2 does not. Only after manually running script2 by clicking "run script" button do I get a reaction. Any idea how I could trigger script2 to react to the changed script1's saved data?
Code of script1
library(gridExtra) # Displaying data onto Power BI Desktop library(dplyr) # For data munging pathToProject <-"F:\\PowerBiDocuments\\" df1 <- group_by(dataset, manufacturer) %>% summarise('avg_cty_mileage' = mean(cty), 'avg_hwy_mileage' = mean(hwy)) saveRDS(df1, paste0(pathToProject,"df1"))
Code of script2
require(gridExtra) require(ggplot2) pathToProject <- "F:\\PowerBiDocuments\\" df2 <- readRDS(paste0(pathToProject,"df1")) grid.table(df2)
Solved! Go to Solution.
No, it's not possible. You must click the "run script" or click "Refresh" to make the R visual take the slicer selection and execute the script again. You may create a feature request on idea.
Regards,
Hey,
I just curious, why can't you just combine both scripts into one like so
library(gridExtra) # Displaying data onto Power BI Desktop library(dplyr) # For data munging df1 <- group_by(dataset, manufacturer) %>% summarise('avg_cty_mileage' = mean(cty), 'avg_hwy_mileage' = mean(hwy))
grid.table(df1)
Regards
Tom
Hey,
I'm not sure if this will help, but maybe you are not aware of the function "grid.arrange"
This little script
library(ggplot2) library(gridExtra) df <- data.frame(cat = c("A", "B"), amount = c(110, 120)) p1 <- ggplot() p1 <- p1 + geom_col(data = df, aes(x = cat, y = amount))
# here starts the modification of the data.frame df that than can used with the function tableGrob
# create a grob (graphical object) from a data frame p2 <- tableGrob(df)
# this creates a single plot that contains "two different plots" that also can be arranged in almost
# any way you want use ?grid.arrange to the documentation of grid.arrange grid.arrange(p1, p2)
creates this output
Maybe this is what you are looking for
Regards Tom
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |