title: How to "Group By" by result and count in Azure App Insights
body: <p>I'm trying to group some results I have in app insights and am struggling</p>
  <p>If I were to tabulate my results, it would look like</p>
  <pre><code>Product        Version
  
   A              1
   B              2
   A              2
   A              1
   B              3
   B              3
  </code></pre>
  <p>As you can see, I have 2 products (A and B), and each has a version number.</p>
  <p>I am trying to group these and provide a count, so my end result is</p>
  <pre><code>Product        Version       Count
  
   A              1              2
   A              2              1 
   B              2              1
   B              3              2
  </code></pre>
  <p>At the moment, my approach is a mess because I am doing this manually with</p>
  <pre><code>customEvents
  | summarise A1 = count(customEvents.['payload.prod'] == &quot;A&quot; and myEvents.['payload.vers'] == &quot;1&quot;),
  | summarise A2 = count(customEvents.['payload.prod'] == &quot;A&quot; and myEvents.['payload.vers'] == &quot;2&quot;)
  </code></pre>
  <p>I have no idea how I can aggregate these so it can group by product and version and then count the occurrences of each</p>