Forum Discussion

rsbin's avatar
rsbin
Community Champion
4 years ago
Solved

Help with R Script - First Timer

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:

DateFacilityWFDVisitCountAvgTIY
3/3/2022ABC18897967
3/4/2022ABC4367947.03
3/5/2022ABC132101534.34
3/6/2022ABC12299594.72
3/7/2022ABC5065732.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,

  • 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")

     

1 Reply

  • rsbin's avatar
    rsbin
    Community Champion

    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")