Forum Discussion

Dante Nahuel Ciai's avatar
Dante Nahuel Ciai
Brass Contributor
Feb 02, 2018

Dashboard two columns

Hi, i'm trying to create a dashboard with a list that gets its data from a Join query, but I can't find any way to add a column to the List on the dashboard, since I need 3 columns; One for the compu...
azure monitor
View Designer
Stanislav_Zhelyazkov's avatar
Stanislav_Zhelyazkov
MVP
Feb 05, 2018

Hi Dante,

Can you be more specific. The query language has functions like join and union. They can be used to merge the results of two queries.

Dante Nahuel Ciai's avatar
Dante Nahuel Ciai
Brass Contributor
Feb 07, 2018

Hi,

Thank you for your reply.

Yes, let me explain:

 

I'm using this query:

Perf
|
where CounterName == "% Committed Bytes In Use" and TimeGenerated > ago(30d)
|
summarize avgRAM = avg(CounterValue) by Computer
|
where avgRAM < 50 |
join (Perf
|
where CounterName == "% Processor Time" and TimeGenerated > ago(30d)
|
summarize avgCPU = avg(CounterValue) by Computer
|
where avgCPU < 50) on Computer
|
project-away Computer1

 

to create a dashboard. If I use the query myself without a dashboard, I can see both columns (first picture). However, when I create a dashboard and use the same query, I can only see the first column.... (second picture)

 

 

 

  • Stanislav_Zhelyazkov's avatar
    Stanislav_Zhelyazkov
    MVP
    Feb 07, 2018

    Hi

    Yes now I understand. Unfortunately dashboards does not support displaying more than one summarized value. My advise would be to create two dashboards side by side - one displaying the first summarized value and another displaying the second summarized value.

Resources