df_data <-
tbl(src_azure, "devicestate") %>%
select(dtm = UTC_DateTime, ActiveCool, Temperature_C, Sum_Power_wh) %>%
filter(DeviceID == input$device) %>%
filter(UTC_DateTime > dtm_range[[1]] & UTC_DateTime < dtm_range[[2]]) %>%
collect()
The line filter(UTC_DateTime > dtm_range[[1]] & UTC_DateTime < dtm_range[[2]])
should work as filter(dtm > dtm_range[[1]] & dtm < dtm_range[[2]])
native support for date-times?
MySQL does not handle %in% for singular values
let's say we want to specify which columns to select
a <- "col_name"
df %>% select(get(a))
data.frames with columns that have attributes (outside of POSIXct) choke the group_by
function