Forum Discussion

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

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