Grouping with an average of it using LINQ to SQL
<p>I have a c# program that I am programing where someone inputs production for the whole day and I calculate the Machine Usage (MU) like this:</p>

<pre><code>Date      | Part Number | Mold Num | Machine Num |  MU  
2/12/2016 | 1185-5B8    |  6580    | 12          |  .428            
2/12/2016 | 2249300     |  7797    | 36          |  .271            
2/12/2016 | 146865      |  5096789 | 12          |  .260            
2/16/2016 | 123456      |  7787    | 56          |  .354            
2/16/2016 | 123456      |  787     | 54          |  .45            
2/16/2016 | 123456      |  777     | 56          |  .799            
2/16/2016 | 123456      |  87      | 54          |  .611          
</code></pre>

<p>How would I group the data that is all in the same table like so:</p>

<pre><code>2/12/2016                   2/16/2016
Machine Num. | MU           Machine Num. | MU
    12       | 34.4%            54       | 53.0%
    36       | 27.1%            56       | 57.6%
</code></pre>

<p>The table where everything is at is called [MU Report]</p>

<p>EDIT:</p>

<p>MU = Time Ran / Time available. So what I did was calculate MU for each individual entry to take an average of it later.</p>