title: Aggregate over multiple columns in Azure (Kusto Query Language)
body: <p>I have clickstream data in Azure monitor logs in this format:</p>
  
  <pre><code>Category   StepName     Count_    Median_Duration(secs)
     A         step1       1200        00:00
     A         step2       1000        24:00
     A         step3        800        19:00
     B         step1       4000        00:00
     B         step2       3800        37:00
  </code></pre>
  
  <p>I need to pivot the table to get this:</p>
  
  <pre><code>Category Step1_Count Step1_Duration Step2_Count Step2_Duration Step3_Count ...
     A       1200          00:00         1000        24:00          800      ...
     B       4000          00:00         3800        37:00           0       ...
  </code></pre>
  
  <p>Right now I am only able to aggregate over one column using evaluate pivot(StepName, sum(Count_)) or evaluate pivot(StepName, sum(Median_Duration)). Is it possible to get the above format without using joins?</p>
  
  <p>Note: Similar formats to the output table are fine, just need the aggregate of the count and duration.</p>