Question: What am I missing to why my plot is all the same and not counting the actual total sales amount?Total Pickle Sales by Month tot

What am I missing to why my plot is all the same and not counting the actual total sales amount?Total Pickle Sales by Month
tot_pick - products %>%
filter(str_detect(product_type, regex('pickles', ignore_case = TRUE)))%>%
inner_join(transactions, by = "product_id")%>%
group_by(Month = month(transaction_timestamp, label = TRUE, abbr = TRUE))%>%
mutate(month = month(transaction_timestamp))%>%
summarise(total_sales = sum(sales_value))
tot_pick %>%
ggplot(aes(Month, total_sales))+
coord_cartesian(ylim = c(0,60))+
geom_col(fill = "lightgreen", color = "darkgreen")+
labs(title = "Total Pickle Sales by Month",
x = "Month",
y = "Total Sales ($)")
 What am I missing to why my plot is all the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!