How to create an expression to average values of 4 rows in a column?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
  • (Edited)
I want to display the overall cpu usage of a server. Is there a way to call out specific instances of a colmn?



The processor load colmn displays the usage of each of my 4 cores. I would like to average the 4 numbers so get an easy to view understanding of how hard my server is working.

Is this even possible?
Photo of David Coglianese

David Coglianese, Embassador

  • 6,504 Points 5k badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Mike Thomas

Mike Thomas, Employee - GTAC - NMS

  • 7,640 Points 5k badge 2x thumb
David, Is this a pre-defined or custom Flexview?
Photo of David Coglianese

David Coglianese, Embassador

  • 6,504 Points 5k badge 2x thumb
This is a custom FlexView to monitor a Windows 2008 server. I do not believe I had to import any mibs  and it is providing data. 
I just want to clean it up so that instead of having to look at the 4 cpu values I can have 1 number which would corispond with the cpu usage displaying by the machine.
https://www.dropbox.com/s/5mdgbsmc7sfbagz/test11.tpl?dl=0
Photo of Mike Thomas

Mike Thomas, Employee - GTAC - NMS

  • 7,640 Points 5k badge 2x thumb
David, we looked at this, we can only do expressions on the same horizontal row. So if you can Span processor load for each CPU into a column you may be in luck in getting an expression to average them out.
(Edited)
Photo of David Coglianese

David Coglianese, Embassador

  • 6,504 Points 5k badge 2x thumb
Mike,
That is great news that is exactly what I need to do, average 4 rows from a single column.
How can we move forward to get this working in my enviroment?
Can you provide an example of what the expression would look like? 

Thanks
Photo of Daniel Flouret

Daniel Flouret, Employee

  • 7,470 Points 5k badge 2x thumb
David, what Mike is saying is that you would have to find a way to put all the values in a single row, as "we can only do expressions on the same horizontal row".

The values to average would have to come from different columns within the same row, not the same column from different rows...
Photo of David Coglianese

David Coglianese, Embassador

  • 6,504 Points 5k badge 2x thumb
Dan,

I got thrown off by him putting column in there. I guess that means I am out of luck.

Thanks for the help.
Photo of David Coglianese

David Coglianese, Embassador

  • 6,504 Points 5k badge 2x thumb
Mike,
That is great news that is exactly what I need to do, average 4 rows from a single column. Can you provide an example of what the expression would look like? 

Thank you for the help and sorry it took so long to get back to you.