Once a dataframe has been set up with the necessary column, we can begin to graph the data and explore visualization options.
The most basic graph can be generated with the
plot() function using the following script:
plot(SQL_Query_1, main = 'Discount Code by Week')
The output of the script can be seen here:
While the plot displays the discount by week, it is difficult to identify the relationship week-to-week without being able to connect the dots.
The following script will connect the dots between each sequential point:
plot(SQL_Query_1, main = 'Discount Code by Week', type="o")
The output ...