a guest Jan 20th, 2019 53 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- interactions := dataset(/interactions)
- lastMonth := interactions where month(interactions.time) > 4 & year(interactions.time) = 2011
- mondays := lastMonth where dayOfWeek(lastMonth.time) = "Monday"
- byHour('hour) := count(mondays where hour(mondays.time) = 'hour)
RAW Paste Data