r - Calculating change of values between same day in different years -
i need calculate called mat (movie anual total), means % change in sales value between same day in 2 different year: id sales day month year 500 31 12 2015 100 1 1 2016 200 2 1 2016 ... 200 1 1 2017 does have idea how deal it? i want this: id sales day month yeas **mat** with way data set up, you're quite close. want group data month , day, order each group year, , take successive differences (assuming want mat sequential years) library(lubridate) library(dplyr) x <- data.frame(date = seq(as.date("2014-01-01"), as.date("2017-12-31"), = 1)) %>% mutate(day = day(date), month = month(date), year = year(date), sales = rnorm(nrow(.), mean = 100, sd = 5)) x %>% group_by(month, day) %>% arrange(month, day, year) %>% mutate(mat = c(na, diff(sales))) %>% ungroup() if wanting abl...