title: App Insights - Pivot result
body: <p>How can I pivot the result of a App Insights analytics query?</p>
  
  <p>For example i would like to have a value-column for every <code>cloud_RoleInstace</code>:</p>
  
  <pre><code>performanceCounters  
  | where timestamp &gt; todatetime("2017-07-24T13:44:00.251Z")  
      and timestamp &lt; todatetime("2017-07-24T13:49:00.251Z")   
  | where name in ("% Processor Time")//, "Request Execution Time")  
  | sort by timestamp asc nulls last  
  | project timestamp, value, cloud_RoleInstance 
  </code></pre>