public IEnumerable <AggregatedEvents> GetEventAggregated(int minutes) //this queries the events ETL
 {
     using (var context = new ETLChatContext())
     {
         return(context.GetAggregatedEvents(minutes));
     }
 }
 public IEnumerable <Event> GetEventTransactions(DateTime start, DateTime end)
 {
     using (var context = new ETLChatContext())
     {
         return(context.GetEventDetails(start, end));
     }
 }