Home

Multidimension timechart

%3CLINGO-SUB%20id%3D%22lingo-sub-210872%22%20slang%3D%22en-US%22%3EMultidimension%20timechart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-210872%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20first%20off%2C%20i've%20already%20reviewed%20this%20answer%2C%20and%20it%20seems%20hacky.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FAzure-Log-Analytics%2FAzure-log-analytics-timechart-with-multiple-dimensions%2Ftd-p%2F108245%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FAzure-Log-Analytics%2FAzure-log-analytics-timechart-with-multiple-dimensions%2Ftd-p%2F108245%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I'd%20like%20to%20do%20it%20view%20the%20CPU%20usage%20of%20my%20content%20delivery%20servers%20and%20the%20count%20of%20participating%20in%20the%20load%20balancer.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20my%20CPU%20query.%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CPRE%3E%3CSPAN%3EPerf%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Ewhere%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%20ObjectName%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22Processor%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20CounterName%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22%25%20Processor%20Time%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20InstanceName%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22_Total%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20Computer%20%3C%2FSPAN%3E%3CSPAN%3Econtains%3C%2FSPAN%3E%20%3CSPAN%3E%22CD%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20TimeGenerated%20%26gt%3B%20ago(%3C%2FSPAN%3E%3CSPAN%3E10%3C%2FSPAN%3E%3CSPAN%3Eh)%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20CounterName%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Esummarize%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%20avg(%20CounterValue%20)%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3Eby%3C%2FSPAN%3E%3CSPAN%3E%20Computer%3Dextract(%40%3C%2FSPAN%3E%3CSPAN%3E%22(%5B%5E%3C%2FSPAN%3E%3CSPAN%3E%5C%3C%2FSPAN%3E%3CSPAN%3E.%5D*)%22%3C%2FSPAN%3E%3CSPAN%3E%2C%20%3C%2FSPAN%3E%3CSPAN%3E1%3C%2FSPAN%3E%3CSPAN%3E%2C%20Computer%20)%2C%20bin(TimeGenerated%2C%20%3C%2FSPAN%3E%3CSPAN%3E15%3C%2FSPAN%3E%3CSPAN%3Em)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Erender%3C%2FSPAN%3E%3CSPAN%3E%20timechart%3C%2FSPAN%3E%3C%2FPRE%3E%3CDIV%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3Eand%20here%20is%20my%20loadbalancer%20dip%20count%20query%26nbsp%3B%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CDIV%3E%3CPRE%3E%3CSPAN%3EAzureDiagnostics%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Ewhere%3C%2FSPAN%3E%3CSPAN%3E%20Category%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22LoadBalancerProbeHealthStatus%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%20Resource%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22SITECORE-PROD-CD-EXTERNAL-LB%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%20TimeGenerated%20%26gt%3B%20ago(%3C%2FSPAN%3E%3CSPAN%3E2%3C%2FSPAN%3E%3CSPAN%3Ed)%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Esummarize%3C%2FSPAN%3E%3CSPAN%3E%20max(totalDipCount_d)%20%3C%2FSPAN%3E%3CSPAN%3Eby%3C%2FSPAN%3E%3CSPAN%3E%20bin(TimeGenerated%2C%20%3C%2FSPAN%3E%3CSPAN%3E5%3C%2FSPAN%3E%3CSPAN%3Em)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Erender%3C%2FSPAN%3E%3CSPAN%3E%20timechart%20%3C%2FSPAN%3E%3C%2FPRE%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3ESo%20I%20want%20to%20combine%20them%2C%20here%20is%20an%20attempt%20at%20that.%26nbsp%3B%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CDIV%3E%3CPRE%3E%3CSPAN%3E%20(Perf%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%20%7C%20%3C%2FSPAN%3E%3CSPAN%3Ewhere%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%20ObjectName%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22Processor%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20CounterName%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22%25%20Processor%20Time%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20InstanceName%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22_Total%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20Computer%20%3C%2FSPAN%3E%3CSPAN%3Econtains%3C%2FSPAN%3E%20%3CSPAN%3E%22CD%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20TimeGenerated%20%26gt%3B%20ago(%3C%2FSPAN%3E%3CSPAN%3E10%3C%2FSPAN%3E%3CSPAN%3Eh)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%20)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Eunion%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%20(AzureDiagnostics%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%20%7C%20%3C%2FSPAN%3E%3CSPAN%3Ewhere%3C%2FSPAN%3E%3CSPAN%3E%20Category%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22LoadBalancerProbeHealthStatus%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%20Resource%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22SITECORE-PROD-CD-EXTERNAL-LB%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%20TimeGenerated%20%26gt%3B%20ago(%3C%2FSPAN%3E%3CSPAN%3E1%3C%2FSPAN%3E%3CSPAN%3Ed)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%20)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Esummarize%3C%2FSPAN%3E%3CSPAN%3E%20max(totalDipCount_d)%2C%20avg(%20CounterValue%20)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3Eby%3C%2FSPAN%3E%3CSPAN%3E%20Computer%3Dextract(%40%3C%2FSPAN%3E%3CSPAN%3E%22(%5B%5E%3C%2FSPAN%3E%3CSPAN%3E%5C%3C%2FSPAN%3E%3CSPAN%3E.%5D*)%22%3C%2FSPAN%3E%3CSPAN%3E%2C%20%3C%2FSPAN%3E%3CSPAN%3E1%3C%2FSPAN%3E%3CSPAN%3E%2C%20Computer%20)%2C%20bin(TimeGenerated%2C%20%3C%2FSPAN%3E%3CSPAN%3E5%3C%2FSPAN%3E%3CSPAN%3Em)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Erender%3C%2FSPAN%3E%3CSPAN%3E%20timechart%3C%2FSPAN%3E%3C%2FPRE%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3BWhich%20is%20close%2C%20I%20am%20getting%20rows%20from%20the%20correct%20datasets%2C%20but%20when%20I%20add%20the%20timechart%2C%20I%20don't%20get%20the%20visualization%20I%20am%20after.%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3EThanks%2C%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3EDevin%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-210872%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-214481%22%20slang%3D%22en-US%22%3ERe%3A%20Multidimension%20timechart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-214481%22%20slang%3D%22en-US%22%3E%3CP%3EHere%20is%20another%20query%20that%20further%20exemplifies%20the%20concept.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CPRE%3E%3CSPAN%3E(%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20Perf%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20%7C%20%3C%2FSPAN%3E%3CSPAN%3Ewhere%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20ObjectName%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22Processor%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20CounterName%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22%25%20Processor%20Time%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20InstanceName%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22_Total%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20Computer%20%3C%2FSPAN%3E%3CSPAN%3Econtains%3C%2FSPAN%3E%20%3CSPAN%3E%22CD%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20Computer%20!%3C%2FSPAN%3E%3CSPAN%3Econtains%3C%2FSPAN%3E%20%3CSPAN%3E%22azecdag01%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20Computer%20!%3C%2FSPAN%3E%3CSPAN%3Econtains%3C%2FSPAN%3E%20%3CSPAN%3E%22azescdb03%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20Computer%20!%3C%2FSPAN%3E%3CSPAN%3Econtains%3C%2FSPAN%3E%20%3CSPAN%3E%22azescdb00%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20TimeGenerated%20%26gt%3B%20ago(%3C%2FSPAN%3E%3CSPAN%3E7%3C%2FSPAN%3E%3CSPAN%3Ed)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20%7C%20%3C%2FSPAN%3E%3CSPAN%3Eproject%3C%2FSPAN%3E%3CSPAN%3E%20CPU_Utilization%3DCounterValue%2C%20TimeGenerated%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Eunion%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E(%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20Perf%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20%7C%20%3C%2FSPAN%3E%3CSPAN%3Ewhere%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20ObjectName%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22Memory%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20CounterName%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22%25%20Committed%20Bytes%20In%20Use%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20TimeGenerated%20%26gt%3B%20ago(%3C%2FSPAN%3E%3CSPAN%3E7%3C%2FSPAN%3E%3CSPAN%3Ed)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20%7C%20%3C%2FSPAN%3E%3CSPAN%3Eproject%3C%2FSPAN%3E%3CSPAN%3E%20Mem_Utilization%3DCounterValue%2C%20TimeGenerated%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Eunion%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E(%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20app(%3C%2FSPAN%3E%3CSPAN%3E%22Sitecore%20Production%22%3C%2FSPAN%3E%3CSPAN%3E).pageViews%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20%7C%20%3C%2FSPAN%3E%3CSPAN%3Ewhere%3C%2FSPAN%3E%3CSPAN%3E%20timestamp%20%26gt%3B%20ago(%3C%2FSPAN%3E%3CSPAN%3E7%3C%2FSPAN%3E%3CSPAN%3Ed)%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20%7C%20%3C%2FSPAN%3E%3CSPAN%3Esummarize%3C%2FSPAN%3E%20%3CSPAN%3Ecount%3C%2FSPAN%3E%3CSPAN%3E()%20%3C%2FSPAN%3E%3CSPAN%3Eby%3C%2FSPAN%3E%3CSPAN%3E%20bin(timestamp%2C%3C%2FSPAN%3E%3CSPAN%3E1%3C%2FSPAN%3E%3CSPAN%3Eh)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20%7C%20%3C%2FSPAN%3E%3CSPAN%3Eproject%3C%2FSPAN%3E%3CSPAN%3E%20TimeGenerated%3Dtimestamp%2C%20pageViews%3Dcount_%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Eunion%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E(%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20app(%3C%2FSPAN%3E%3CSPAN%3E%22Sitecore%20Production%22%3C%2FSPAN%3E%3CSPAN%3E).pageViews%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20%7C%20%3C%2FSPAN%3E%3CSPAN%3Ewhere%3C%2FSPAN%3E%3CSPAN%3E%20timestamp%20%26gt%3B%20ago(%3C%2FSPAN%3E%3CSPAN%3E7%3C%2FSPAN%3E%3CSPAN%3Ed)%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20%7C%20%3C%2FSPAN%3E%3CSPAN%3Esummarize%3C%2FSPAN%3E%20%3CSPAN%3Ecount%3C%2FSPAN%3E%3CSPAN%3E()%20%3C%2FSPAN%3E%3CSPAN%3Eby%3C%2FSPAN%3E%3CSPAN%3E%20session_Id%2C%20bin(timestamp%2C%3C%2FSPAN%3E%3CSPAN%3E1%3C%2FSPAN%3E%3CSPAN%3Eh)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20%7C%20%3C%2FSPAN%3E%3CSPAN%3Esummarize%3C%2FSPAN%3E%20%3CSPAN%3Ecount%3C%2FSPAN%3E%3CSPAN%3E()%20%3C%2FSPAN%3E%3CSPAN%3Eby%3C%2FSPAN%3E%3CSPAN%3E%20bin(timestamp%2C%20%3C%2FSPAN%3E%3CSPAN%3E1%3C%2FSPAN%3E%3CSPAN%3Eh)%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20%7C%20%3C%2FSPAN%3E%3CSPAN%3Eproject%3C%2FSPAN%3E%3CSPAN%3E%20TimeGenerated%3Dtimestamp%2C%20sessions%3Dcount_%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Esummarize%3C%2FSPAN%3E%3CSPAN%3E%20avg_pageviewsx100%3Davg(pageViews)%2F%3C%2FSPAN%3E%3CSPAN%3E100%3C%2FSPAN%3E%3CSPAN%3E%2C%20avg_sessionsx100%3Davg(sessions)%2F%3C%2FSPAN%3E%3CSPAN%3E100%3C%2FSPAN%3E%3CSPAN%3E%2C%20avg(CPU_Utilization)%2C%20avg(Mem_Utilization)%20%3C%2FSPAN%3E%3CSPAN%3Eby%3C%2FSPAN%3E%3CSPAN%3E%20bin(TimeGenerated%2C%20%3C%2FSPAN%3E%3CSPAN%3E1%3C%2FSPAN%3E%3CSPAN%3Eh)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Erender%3C%2FSPAN%3E%3CSPAN%3E%20timechart%20%3C%2FSPAN%3E%3C%2FPRE%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F37443i1639644B5E710CAB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-214478%22%20slang%3D%22en-US%22%3ERe%3A%20Multidimension%20timechart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-214478%22%20slang%3D%22en-US%22%3E%3CP%3ESorry%2C%20I%20never%20got%20notified%20on%20your%20reply.%20I%20realized%20the%20fundamental%20issue%20with%20my%20problem.%20I%20didn't%20have%20a%20common%20Y%20Axis.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20a%20new%20query.%3C%2FP%3E%3CDIV%3E%3CPRE%3E%3CSPAN%3E%20(%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20Perf%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20%7C%20%3C%2FSPAN%3E%3CSPAN%3Ewhere%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20ObjectName%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22Processor%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20CounterName%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22%25%20Processor%20Time%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20InstanceName%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22_Total%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20Computer%20%3C%2FSPAN%3E%3CSPAN%3Econtains%3C%2FSPAN%3E%20%3CSPAN%3E%22CD%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20TimeGenerated%20%26gt%3B%20ago(%3C%2FSPAN%3E%3CSPAN%3E7%3C%2FSPAN%3E%3CSPAN%3Ed)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20%7C%20%3C%2FSPAN%3E%3CSPAN%3Eproject%3C%2FSPAN%3E%3CSPAN%3E%20CPU_Utilization%3DCounterValue%2C%20TimeGenerated%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Eunion%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E(%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20AzureDiagnostics%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20%7C%20%3C%2FSPAN%3E%3CSPAN%3Ewhere%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20Category%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22LoadBalancerProbeHealthStatus%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20Resource%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22SITECORE-PROD-CD-EXTERNAL-LB%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20TimeGenerated%20%26gt%3B%20ago(%3C%2FSPAN%3E%3CSPAN%3E7%3C%2FSPAN%3E%3CSPAN%3Ed)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20%7C%20%3C%2FSPAN%3E%3CSPAN%3Eproject%3C%2FSPAN%3E%3CSPAN%3E%20TimeGenerated%2C%20dipCount%3DtotalDipCount_d%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Esummarize%3C%2FSPAN%3E%3CSPAN%3E%20dipCount%3Dmax(dipCount)*%3C%2FSPAN%3E%3CSPAN%3E10%3C%2FSPAN%3E%3CSPAN%3E%2C%20avg(CPU_Utilization)%20%3C%2FSPAN%3E%3CSPAN%3Eby%3C%2FSPAN%3E%3CSPAN%3E%20bin(TimeGenerated%2C%20%3C%2FSPAN%3E%3CSPAN%3E1%3C%2FSPAN%3E%3CSPAN%3Eh)%20%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%3E%2F%2F%2C%20Computer%3Dextract(%40%22(%5B%5E%5C.%5D*)%22%2C%201%2C%20Computer%20)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Erender%3C%2FSPAN%3E%3CSPAN%3E%20timechart%20%3C%2FSPAN%3E%3C%2FPRE%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F37434iFC9E1F4CC86BD17C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-213239%22%20slang%3D%22en-US%22%3ERe%3A%20Multidimension%20timechart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-213239%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Devin%2C%3C%2FP%3E%0A%3CP%3EI'm%20not%20sure%20what%20you%20get%20vs.%20what%20you%20want%20to%20get%20-%20can%20you%20add%20a%20picture%3F%3C%2FP%3E%0A%3CP%3EI've%20created%20a%20%3CA%20href%3D%22https%3A%2F%2Fportal.loganalytics.io%2Fsubscriptions%2Fe4272367-5645-4c4e-9c67-3b74b59a6982%2Fresourcegroups%2FContosoAzureHQ%2Fworkspaces%2Fcontosoretail-IT%3Fq%3DH4sIAAAAAAAAA32QwUoDQQyG7wXfISwIW%252BjFg8cVSoUiiBYpXks6G7cjO8mSmbFs6cObLbqtIh6GmUy%252B%252FPmTckX6djWBI%252Bx3pATP23dy6QkDQVVBsVJxFKNoYQwAcg0LyZxIR%252BQaRgjWPtCZfOCYkB2N6GYtCdtLqdBl0wInnNBzhGJhL4lyZgbJJTEpJqrhDrCR8mY3tbydI2T2whaU80NWuvfYsMTkXbyYaWGljWhfVcW861rvMFnR0n732A%252Fzi4bB56M0xannC0XJ6ugPX2C6%252F9s6QqcyLPEnM4PWLnb9pv72HnMIqP5AgB9NOaans1P8tedXbDNNYdvD1nP5S%252FI2nISUuLYtJku6HWqafAL9iaxG1gEAAA%253D%253D%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Esimilar%20query%20on%20our%20demo%20data%3C%2FA%3E%3A%3C%2FP%3E%0A%3CPRE%3E(Perf%0A%20%7C%20where%20ObjectName%20%3D%3D%20%22Processor%22%0A%20%20%20and%20CounterName%20%3D%3D%20%22%25%20Processor%20Time%22%0A%20%20%20and%20InstanceName%20%3D%3D%20%22_Total%22%0A%20%20%20and%20Computer%20contains%20%22Contoso%22%0A%20%20%20and%20TimeGenerated%20%26gt%3B%20ago(1h)%0A%20)%0A%7C%20union%0A%20(AzureDiagnostics%0A%20%7C%20where%20Category%3D%3D%22ApplicationGatewayPerformanceLog%22%20and%20Resource%20contains%20%22Contoso%22%20%0A%20and%20TimeGenerated%20%26gt%3B%20ago(1h)%0A%20%7C%20project%20TimeGenerated%2C%20latency_d%0A%20)%0A%7C%20summarize%20avg(latency_d)%2C%20avg(CounterValue)%20by%20bin(TimeGenerated%2C%205m)%0A%7C%20render%20timechart%3C%2FPRE%3E%0A%3CP%3Eand%20it%20produces%20this%20output%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F37232iC3F27FA1B669A273%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22union.png%22%20title%3D%22union.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EWere%20you%20aiming%20for%20something%20very%20different%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Devin Lambert
Occasional Contributor

Hello,

 

So first off, i've already reviewed this answer, and it seems hacky. 

https://techcommunity.microsoft.com/t5/Azure-Log-Analytics/Azure-log-analytics-timechart-with-multip...

 

What I'd like to do it view the CPU usage of my content delivery servers and the count of participating in the load balancer. 

 

Here is my CPU query. 

Perf

| where

ObjectName == "Processor"

and CounterName == "% Processor Time"

and InstanceName == "_Total"

and Computer contains "CD"

and TimeGenerated > ago(10h)

and CounterName

| summarize

avg( CounterValue )

by Computer=extract(@"([^\.]*)", 1, Computer ), bin(TimeGenerated, 15m)

| render timechart
 
and here is my loadbalancer dip count query 
AzureDiagnostics

| where Category == "LoadBalancerProbeHealthStatus"

and

Resource == "SITECORE-PROD-CD-EXTERNAL-LB"

and

TimeGenerated > ago(2d)

| summarize max(totalDipCount_d) by bin(TimeGenerated, 5m)

| render timechart
 
So I want to combine them, here is an attempt at that. 
 
 (Perf

| where

ObjectName == "Processor"

and CounterName == "% Processor Time"

and InstanceName == "_Total"

and Computer contains "CD"

and TimeGenerated > ago(10h)

)

| union

(AzureDiagnostics

| where Category == "LoadBalancerProbeHealthStatus"

and

Resource == "SITECORE-PROD-CD-EXTERNAL-LB"

and

TimeGenerated > ago(1d)

)

| summarize max(totalDipCount_d), avg( CounterValue )

by Computer=extract(@"([^\.]*)", 1, Computer ), bin(TimeGenerated, 5m)

 

| render timechart
 
 Which is close, I am getting rows from the correct datasets, but when I add the timechart, I don't get the visualization I am after. 
 
Thanks,
Devin
3 Replies

Hi Devin,

I'm not sure what you get vs. what you want to get - can you add a picture?

I've created a similar query on our demo data:

(Perf
 | where ObjectName == "Processor"
   and CounterName == "% Processor Time"
   and InstanceName == "_Total"
   and Computer contains "Contoso"
   and TimeGenerated > ago(1h)
 )
| union
 (AzureDiagnostics
 | where Category=="ApplicationGatewayPerformanceLog" and Resource contains "Contoso" 
 and TimeGenerated > ago(1h)
 | project TimeGenerated, latency_d
 )
| summarize avg(latency_d), avg(CounterValue) by bin(TimeGenerated, 5m)
| render timechart

and it produces this output:

union.png

Were you aiming for something very different?

Sorry, I never got notified on your reply. I realized the fundamental issue with my problem. I didn't have a common Y Axis. 

 

Here is a new query.

 (
Perf
| where
ObjectName == "Processor"
and CounterName == "% Processor Time"
and InstanceName == "_Total"
and Computer contains "CD"
and TimeGenerated > ago(7d)
| project CPU_Utilization=CounterValue, TimeGenerated
)
| union
(
AzureDiagnostics
| where
Category == "LoadBalancerProbeHealthStatus"
and Resource == "SITECORE-PROD-CD-EXTERNAL-LB"
and TimeGenerated > ago(7d)
| project TimeGenerated, dipCount=totalDipCount_d
)
| summarize dipCount=max(dipCount)*10, avg(CPU_Utilization) by bin(TimeGenerated, 1h)
//, Computer=extract(@"([^\.]*)", 1, Computer )
| render timechart

 

 

image.png

Here is another query that further exemplifies the concept. 

 

(
Perf
| where
ObjectName == "Processor"
and CounterName == "% Processor Time"
and InstanceName == "_Total"
and Computer contains "CD"
and Computer !contains "azecdag01"
and Computer !contains "azescdb03"
and Computer !contains "azescdb00"
and TimeGenerated > ago(7d)
| project CPU_Utilization=CounterValue, TimeGenerated
)
| union
(
Perf
| where
ObjectName == "Memory"
and CounterName == "% Committed Bytes In Use"
and TimeGenerated > ago(7d)
| project Mem_Utilization=CounterValue, TimeGenerated
)
| union
(
app("Sitecore Production").pageViews
| where timestamp > ago(7d)
| summarize count() by bin(timestamp,1h)
| project TimeGenerated=timestamp, pageViews=count_
)
| union
(
app("Sitecore Production").pageViews
| where timestamp > ago(7d)
| summarize count() by session_Id, bin(timestamp,1h)
| summarize count() by bin(timestamp, 1h)
| project TimeGenerated=timestamp, sessions=count_
)
| summarize avg_pageviewsx100=avg(pageViews)/100, avg_sessionsx100=avg(sessions)/100, avg(CPU_Utilization), avg(Mem_Utilization) by bin(TimeGenerated, 1h)
| render timechart

image.png

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies