Dashboard two columns

[Dante Nahuel Ciai]

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?

[#2]

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.

[#3]

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)

[#4]

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.