Forum Discussion
Dashboard two columns
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)
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.