This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
How can I quickly Count, different object types in a MainView tabular summary view ?
This process is valid for all tabular views, the example shown here is from the CMF view DEVSTATZ.
The view DEVSTATZ is a Summary view, indicated by the Z at the end of the view name.
We can see that 195 rows of data are presented in the view.
We can also see that the second column is the device type (3490 or 3390).
We can enter the SUM command and place our cursor on the second column and press enter.
The result is a summary view by Device Type :
In this example we now have 2 data lines for each model type, one for 3390 and one for 3490.
Also notice that because of the summarization type, all of the numeric values represented are the average, clearly explained in the help panel display.
Our interest is to know how many device type are counted in this summary.
We can now enter the view customization , enter CUST in the command line and press enter. We will now create a count column using R(epeat) B. We choose the same column used for the summarization.
The result is a new column (C) is created. We format the new column with the command F(ormat) C.
So let's make the field a little bit larger, change the Heading and most important change the Summarization type to C(ount) :
We now have a new column that represents the count of each device type :
Note that the fields are still summarized but now the value represents the average per device type as the help panel explains.