I have the dataset of a distribution company. The actual result that I am looking for is to get the response efficiency when I divide Response over the Billed Population. The challenge here is that the data set there's no billed population as a variable, so I'll have to convert the individual billed energy to represent the billed population and then divide by the Response. How do I go about it?
Response <- df %>% mutate(Char = nchar(Payment.Efficiency....))%>% filter(!Char == "NotBilled")%>% group_by(Zone) %>% summarise(BilledPop = count(Char >0), Response = count(Resp >0), Efficiency = Response/Char) #> Error in df %>% mutate(Char = nchar(Payment.Efficiency....)) %>% filter(!Char == : could not find function "%>%" Response #> Error in eval(expr, envir, enclos): object 'Response' not found
Created on 2020-05-19 by the reprex package (v0.3.0)