Create horizon chart on R using ggplot2: show percentage change

user_9987213 0
Viewed 532

I am a beginner at this and am really lost about it.

I would like to create a horizon chart that shows the percentage change in sales for the different towns using ggplot2 and R. Would anyone guide me in the approach I can take to create the chart?

The data that I have looks like this. enter image description here

This is the type of chart I would like to do. (source: https://harmoniccode.blogspot.com/2017/11/friday-fun-li-horizon-charts.html) enter image description here

Thanks in advance for any help given!

Edit: here's a sample code of the data:

x <- data.frame(
  "town" =c('sad','sad','sad','sad','happy','happy','happy','happy'),
  "month"=c("2017-01","2017-02","2017-03","2017-04","2017-01","2017-02","2017-03","2017-04"),
  "median_sales" = c(336500,355000,375000,395000,359000,361500,36000,375000),
  "percentage_change" = c(NA,5.4977712,5.6338028,5.3333333,NA,0.6963788,-0.4149378,  4.1666667
))

x <-
  x %>%
  mutate(month = floor_date(as_date(as.yearmon(month)), "month"))
ggplot2 r visualization
1 Answers

It would be helpful to give an example that will result in a reasonable plot, and to provide your example data as data rather than an image.

If you google 'horizon plot' the first answer should give you what you need.

Here is a simple example based on the data you gave:

library(latticeExtra)

sales.ts <- ts(matrix(sales$median_sales, ncol=2), names = c("sad", "happy"),
               start = c(2017, 1), frequency = 365)

horizonplot(sales.ts)

I think this is correctly presenting your results, but again hard to tell as you haven't given a realistic dataset.

UPDATE: based on the data provided, this is the answer. Again, as you've only provided one time point a horizonplot is probably not what you want. They are designed to plot time series.

x.ts <- ts(matrix(x$median_sales, ncol=2), names = c("sad", "happy"),
                  start = c(2015, 1), frequency = 12)

horizonplot(x.ts)
user_28280800
Related