Dashboard two columns

Contributor

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 computer name, one for CPU and one for RAM

is there any way?

3 Replies

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.

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)

query.pngquerydashboard.png

 

 

 

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.