Arrange days of the week on x axis while plotting

[Arshia]

This is my code :

ggplot(data=daily_activity_new) +
geom_bar(aes(x=day_of_the_week)) +
labs(title="count of users logged in per day", x="Day of the week", y="frequency")

output : weekdays are displayed in the format 'Fri Mon Sat Sun thurs Tues Wed' on x axis

I want it to be displayed in either of the below formats

1. In order sun mon tue etc
2. desc based on count/frequency

I tried using fact() methods to reorder or arrange in desc but it's not working. the error says fact cant be applied on dataframe.

can anyone please help and let me know how to go about this?

[M_AcostaCH]

Hi, please put a reproducible example for better help all the community:
Copy and paste the result of run this:

dput(daily_activity_new[ 1:30,]  # check take all days

FAQ: How to do a minimal reproducible example ( reprex ) for beginners

A minimal reproducible example consists of the following items: A minimal dataset, necessary to reproduce the issue The minimal runnable code necessary to reproduce the issue, which can be run on the given dataset, and including the necessary information on the used packages. Let's quickly go over each one of these with examples: Minimal Dataset (Sample Data) You need to provide a data frame that is small enough to be (reasonably) pasted on a post, but big enough to reproduce your issue. Let's say, as an example, that you are working with the iris data frame head(iris) #> Sepal.Length Sepal.Width Petal.Length Petal.Width Species #> 1 5.1 3.5 1.4 0.…

[M_AcostaCH]

Im make a toy data:

library(tidyverse)
daily_activity_new <- data.frame(day_of_the_week=c("Saturday","Monday" ,"Thursday", "Wednesday",  "Friday", "Sunday"),
                                  freq=c(12,16,8,22,31,39))       

# For oder the days 
daily_activity_new$day_of_the_week <- factor(daily_activity_new$day_of_the_week, c("Monday", "Tuesday", "Wednesday", "Thursday","Friday","Saturday", "Sunday"))

ggplot(data=daily_activity_new) +
  geom_col(aes(x=day_of_the_week, y=freq)) +
  labs(title="count of users logged in per day", x="Day of the week", y="frequency")

Maybe is better if you put the data. Because if you want order by desc the frequency, so will change the days order.

[Arshia]

Hey,

Thanks for your input. I have actually figured a way out to display it in asc or desc now. However unable to plot it in the order of days of the week. eg sun mon tue wed etc. Below is my modified code

ggplot(daily_activity_new, aes( x = reorder(day_of_the_week,day_of_the_week,function(x)-length(x)))) + geom_bar()

[M_AcostaCH]

@M_AcostaCH

daily_activity_new$day_of_the_week <- factor(daily_activity_new$day_of_the_week, c("Monday", "Tuesday", "Wednesday", "Thursday","Friday","Saturday", "Sunday"))

Before the plot you could set the order of days, like this :

# in this order appear in the plot.
daily_activity_new$day_of_the_week <- factor(daily_activity_new$day_of_the_week, c("Monday", "Tuesday", "Wednesday", "Thursday","Friday","Saturday", "Sunday"))