title: How to union two LINQ queries (WhereSelectEnumerableIterator) error
body: <p>I am trying to build aKendo bar chart. I need the number of tickets opened, and tickets closed. I need that result grouped by month. Here is my LINQ</p>
  
  <pre><code>Dim openTickets = (From t In queue _
                     Where _
                     (t.CreateDate.Year = Convert.ToDateTime(DateTime.Now).Year)
                     Group t By _
                     ID = CType(t.CreateDate.Month, Integer), _
                     Month = CType(t.CreateDate.ToString("MMMM"), String) _
                     Into g = Group _
                     Select New With _
                     {.Month = Month.Substring(0, 3), .Opened = g.Where(Function(t) t.CreateDate.Month = ID).Count(Function(t) t.Id)})
  
  Dim closedTickets = (From t In queue _
                     Where _
                     (t.CloseDate.Year = Convert.ToDateTime(DateTime.Now).Year)
                     Group t By _
                     ID = CType(t.CloseDate.Month, Integer), _
                     Month = CType(t.CloseDate.ToString("MMMM"), String) _
                     Into g = Group _
                     Select New With _
                     {.Month = Month.Substring(0, 3), .Closed = g.Where(Function(t) t.CloseDate.Month = ID).Count(Function(t) t.Id)})
  
  Dim ticketCount = openTickets.Union(closedTickets)
  </code></pre>
  
  <p>When I try this, I get "WhereSelectEnumerableIterator". If I change the second query so that the name is ".Opened" and not ".Closed" it works, but then I do not know my count for "closed".</p>
  
  <p>Ultimately I am trying to get an output of an array to supply the chart... similar to this:</p>
  
  <pre><code>[{"Month":"Apr","Opened":138,"Closed":150}
  
  INSTEAD OF
  
  [{"Month":"Apr","Opened":138,"Closed":0},{"Month":"Apr","Opened":0,"Closed":150}
  </code></pre>