Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello,
Looking for help from anyone experienced in R Scripts
First time trying to use the R Script Visual to create an x-y scatter plot.
I have the following table of sample data:
Date | Facility | WFD | VisitCount | AvgTIY |
3/3/2022 | ABC | 188 | 979 | 67 |
3/4/2022 | ABC | 43 | 679 | 47.03 |
3/5/2022 | ABC | 132 | 1015 | 34.34 |
3/6/2022 | ABC | 122 | 995 | 94.72 |
3/7/2022 | ABC | 50 | 657 | 32.25 |
Facility will be used as a Filter or Slicer so not needed in the plot itself.
My hypothesis is that AvgTIY is influenced by WFD and VisitCount.
Each Date should represent a single point in the plot.
x=WFD, y=VisitCount, size= AvgTIY. After watching several videos, I have got to this point:
# The following code to create a dataframe and remove duplicated rows is always executed and acts as a preamble for your script:
# dataset <- data.frame(WFD, VisitCount, AvgTIY)
# dataset <- unique(dataset)
# Paste or type your script code here:
library(ggplot2)
ggplot(data=dataset, aes(x=VisitCount,
y=WFD))
geom_point(aes(size=AvgTIY), color= "Blue")
But my visual is empty.
Hoping someone can lend me the assistance I need to generate the plot.
Thanks in advance and Best Regards,
Solved! Go to Solution.
After more research, I believe I found my issue.
Missed the "+" sign, which I now know is required in order for R to keep reading the code.
# The following code to create a dataframe and remove duplicated rows is always executed and acts as a preamble for your script:
# dataset <- data.frame(WFD, VisitCount, AvgTIY)
# dataset <- unique(dataset)
# Paste or type your script code here:
library(ggplot2)
ggplot(data=dataset, aes(x=VisitCount,
y=WFD)) +
geom_point(aes(size=AvgTIY), color= "Blue")
After more research, I believe I found my issue.
Missed the "+" sign, which I now know is required in order for R to keep reading the code.
# The following code to create a dataframe and remove duplicated rows is always executed and acts as a preamble for your script:
# dataset <- data.frame(WFD, VisitCount, AvgTIY)
# dataset <- unique(dataset)
# Paste or type your script code here:
library(ggplot2)
ggplot(data=dataset, aes(x=VisitCount,
y=WFD)) +
geom_point(aes(size=AvgTIY), color= "Blue")