title: I need a query to measure network bandwidth utilization in Azure using KQL
body: <p>To start, I am new to KQL.  I am trying to write a query that provides me with an overall network utilization of my VM's.</p>
  <p>Below is what I have currently:</p>
  <pre><code>Perf
  | where ObjectName == &quot;Network Interface&quot;
  | where Computer startswith &quot;T1&quot;
  | where CounterPath contains &quot;Bytes Received&quot;or
      CounterPath contains &quot;Current Bandwidth&quot;
  | project Computer, ObjectName, CounterName, CounterValue, CounterPath
  | sort by Computer
  | summarize avg(CounterValue) by Computer, CounterName
  </code></pre>
  <p>and it returns the two rows of data for each computer (one row for Bytes Received and one row for Current Bandwidth)</p>
  <p>What I need to accomplish is combine the two rows of data for each computer with the equation <code>((Total Bytes\Sec * 8)/current bandwidth) * 100</code> - and this should produce a single data point for each computer.</p>
  <p>Can someone help me accomplish this?</p>