I have a table of technologies (WindowsOS, LinuxOS, OracleDB, JBossWeb, etc) and associated security compliance ratings based on some metric evaluations. An example table of results looks like this:
Technology | Compliance
WindowsOS | 92
LinuxOS | 89
OracleDB | 72
What I would like is to add another row for an Overall Compliance rating, which would be an average of the Compliance values.
addcoltotals works perfectly from a format perspective but I need an average rather than a total.
Ultimately I would like to get a result like this:
Technology | Compliance
WindowsOS | 92
LinuxOS | 89
OracleDB | 72
Overall | 84
I am using the results to drive a radial gauge visualization and I would like to Trellis it by Technology so it will display compliance ratings for each technology component as well as an overall rating.
I can obviously create a separate panel for the overall rating and a trellis panel to visualize each technology but I would prefer to have all in one.
The number of rows will vary from 1 to however many technologies are in use for a system. eval doesn't support stats functions or this would be very straightforward. Is there a way to get a count of the rows returned that can be used in an eval command or some other method of doing this that I am missing?
... View more