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 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.


Thank you for your reply.

Yes, let me explain:


I'm using this query:

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)






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.