CODEWITHSUNDEEP
azure-data-explorerkql
user1396982
user1396982

Reputation: 125

KUSTO display two series of data

I have this query and the data display my graph and I have to select on the dropdown on graph chart data_in_Gbps and data_out_Gbps

However, I am interested in adding both data on the graph instead of currently I have to create 2 graphs. what needs to add to show both data on graph?

  Azure
 | where ResourceId contains "tedr"
 | where MetricName == "BitsInPerSecond"
 | where TimeGenerated > (now() - 300h) and TimeGenerated <= now()
 | project TimeGenerated, Resource, MaxInBps =Maximum
 | join kind= inner
  (
 Azure
  | where MetricName == "BitsOutPerSecond"
  | where TimeGenerated > (now() - 300h) and TimeGenerated <= now()
  | project TimeGenerated, Resource, MaxOutBps= Maximum
  )
  on TimeGenerated, Resource
  | summarize data_in_Gbps = max(MaxInBps)/100* 100, data_in_Gbps = max(MaxOutBps)/1000 * 100 by bin(TimeGenerated, 5m), Resource

Thanks!!

Upvotes: 1

Views: 6526

Answers (1)

Dan Hadari
Dan Hadari

Reputation: 264

2 series are not supported when they are also have other dimensions, in your case by ResourceId. Removing the split by ResourceId by selecting Don't split will allow you to select multiple series

enter image description here

Upvotes: 1

Related Questions