R - plotly - cannot sort graph by value

Question

I have some data that is sorted but in plotly the horizontal bar is only sorting in reverse alphabetical order but I need it to sort by a VALUE which is a number; see image 'YOY' column. enter image description here

ecomm_yoy <- ecomm_data2019 %>%
      inner_join(ecomm_data2018, by = "Brand") %>%
      mutate(YOY = round(((Value.x - Value.y)/Value.y)*100, 2)) 

    ecomm_yoy2 <- ecomm_yoy[order(-ecomm_yoy$YOY),]

    plot_ly(x = ecomm_yoy2$YOY, y = ecomm_yoy2$Brand, type = 'bar', orientation = 'h')

enter image description here

No because this is to order data by categories and I am trying to order by the number output as shown by YOY in the image. I tried all the similar posts before posting the question. — Matthew Appleyard
– Matthew Appleyard, Commented Jul 1, 2019 at 11:54

José Luiz Ferreira · Accepted Answer · 2019-07-01 12:19:04Z

3

Add (using a pipe) this layout to your chart:

layout(yaxis = list(categoryorder = "array", categoryarray = ecomm_yoy2$YOY))

edited Jul 1, 2019 at 12:19

answered Jul 1, 2019 at 11:55

José Luiz Ferreira

5753 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Matthew Appleyard Over a year ago

Error in UseMethod("layout") : no applicable method for 'layout' applied to an object of class "list" plot_ly(x = ecomm_yoy2$YOY, y = ecomm_yoy2$Brand, type = 'bar', orientation = 'h') + layout(xaxis = list(categoryorder = array, categoryarray = ecomm_yoy2$YOY))

José Luiz Ferreira Over a year ago

@MatthewAppleyard replace + to a pipe. I will edit my answer to be more specific.

Matthew Appleyard Over a year ago

With pipe another error! Error in unique.default(x) : unique() applies only to vectors

José Luiz Ferreira Over a year ago

This works for me: data <- mtcars %>% mutate(name = rownames(mtcars)) %>% arrange(-hp) plot_ly(data = data, x = ~hp, y= ~name, type='bar', orientation = 'h') %>% layout(yaxis = list(categoryorder = "array", categoryarray = data$name)) I still don't see how it is different than your case. :-(

Matthew Appleyard Over a year ago

I added an layout x axis as well and it worked. Thanks a lot for your help. Finally it worked like this: plot_ly(x = ecomm_yoy2$YOY, y = ecomm_yoy2$Brand, type = 'bar', orientation = 'h') %>% layout(xaxis = list(dtick = 5)) %>% layout(yaxis = list(categoryorder = "array", categoryarray = ecomm_yoy2$YOY))

|

Collectives™ on Stack Overflow

R - plotly - cannot sort graph by value

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related