Table Views

Table views are the most useful way to show vertically and horizontally dense data, include multiple metrics, many items, or many properties. Tables let you sort the data according to any metrics, so you can view the best and worst results for each metric.
capm360
HID_Table_Views
Table views are the most useful way to show vertically and horizontally dense data, include multiple metrics, many items, or many properties. Tables let you sort the data according to any metrics, so you can view the best and worst results for each metric.
Business hours filtering can apply to the data in table views. The applied business hours filter appears in the subtitle. For more information, see Configure Business Hours Filtering.
2
Table View Options
Table views provide the following functionality:
  • To drill down to detailed data for individual items, click the item name.
  • To sort by a particular column or reverse the sort order, click the column heading. An arrow icon indicates the sorted column.
    When you sort by a different column,
    CA Performance Management
    queries the data source to get new results for the table that match the top values for the new sorted column. The sort order applies only to the currently rendered view. The sort order does not persist and cannot be saved on the view.
  • For column options, mouseover column heading and click the gear icon. Use the following options to manage columns:
    • Sort Ascending/Sort Descending
      Sort the entire data set from the data source.
    • Sort Results Ascending/Sort Results Descending
      Sort the already retrieved and rendered result set.
    • Add/Hide Columns
      Expand the Columns menu, and select or clear columns for the table. This list includes the selected metrics from the view configuration and more details about the items, such as Alias and Life Cycle State.
    • Move
      Click and drag the column header to the desired location.
    • Resize
      Hover over the separator line between two columns in the grid header, and click and drag the column to be wider or narrower.
    • Save
      Save the column settings for the view at the tenant, user, or session level. The save operation is applied only to the column selection and the order of columns.
      Save does not preserve column sort order.
    • Use Default Settings
      Revert any custom changes applied to the view column settings.
  • By default,
    Enable Scrolling
    is selected and the Search bar is locked in place when you display more than 20 rows. To change this setting, click the
    Max Per Page
    drop-down in the lower-right corner, and change
    Enable Scrolling
    .
Bar Chart Table Views
Some out-of-the-box views, show tables with a bar chart column. These views show metrics with percentage values. Use these views to identify problematic devices quickly.
The following example shows the important elements of a bar chart table:
Table Bar Chart Elements
Table Bar Chart Elements
Deviations from Normal Table Views
The Top Deviations from Normal views compare actual values from the selected time frame to a calculated baseline value. Use these views to identify places where performance has changed. These views display the items that deviated the most from that normal value. The way the baseline is calculated varies by data source.
The table shows the following information:
  • The average for the selected metric
  • The average baseline for the selected metric
  • The percent divination with a relative visualization sorted by absolute value
Edit the view to specify the following information:
  • The type of device: router, server, or switch
  • The selected metric
The following example shows the important elements of a deviations from normal table:
Deviations from Normal Table Elements
Deviations from Normal Table Elements
Chart/Table Views
Chart/table views combine aspects of other visualizations with table views. These views support only percentage type metrics.
3
When you print a combi-view, only the table portion of the view appears in the PDF.
Gauge/Table Views
Gauge/table views highlight where the value of one metric differs from the expected value when compared to other metrics. These views are good for metrics where the value is a percentage. The gauge shows the minimum, maximum, and average values for one item in the time range. The table lets you see the values for all items and select the item to show on the gauge.
The gauge chart legend shows the resolution, which specifies the granularity of the reporting data: as polled, hourly rollup, or daily rollup. For customized views, the minimum and maximize thresholds are based on this resolution. For out of the box views, the minimum and maximum thresholds are based on the as polled resolution.
The following example shows the important elements of a gauge/table view:
Gauge Table Elements
Gauge Table Elements
Trend/Table Views
Trend/table views provide the flexibility of table data and use the trend view to show the change in a metric over time. The trend shows the value over the time range for one item. The table lets you see the values for all items and select the item to show on the trend. Percentage-based metrics are represented with a bar.
Most trend/table views have a trend chart that shows the value of a single metric. Some trend/table views have a trend chart that shows the value of multiple metrics. Each metric is represented with its own trend line.
The following example shows the important elements of a trend/table view:
Trend Table Elements
Trend Table Elements
Radial Bar/Table Views
Radial bar/table views show percentage values within a circular bar.
The following example shows the important elements of a radial bar/table view:
Radial_Bar
Radial_Bar
Pie/Table Views
Pie/table views show the relative values of a metric. When you hover over the corresponding item in the table, the corresponding slice of pie pops out. Use pie charts to view metric values that represent parts of a whole. Pie charts are best used for small groups of items.
The following example shows the important elements of a pie/table view:
Pie_Table_View
Pie_Table_View
Configure Chart/Table Views
The IM Custom Chart-Table view is a custom view for data from the Data Aggregator data source.
Not all settings are available for all table view types. For standard view configuration details, see Customize Views.
Follow these steps:
  1. Select a
    Chart Type
    .
  2. Select the
    Metric Name
    from the list of metrics for the selected metric family. This option determines the selected metric for the view.
  3. If you are configuring a custom view, select the
    Metric Calculate Level
    .
    This option determines what level of aggregation each row in the view represents: a device, or a component.
  4. Change definitions for the status levels:
    • Minor Status Start
      Metrics before this value have a normal status indicated with green.
      Metrics at or after this value have a minor status indicated with yellow.
    • Major Status Start
      Metrics at or after this value have a major status indicated with orange.
    • Critical Status Start
      Metrics at or after this value have a critical status indicated with red.
    Some out-of-the-box views show
    Moderate Status Start
    . For these views, moderate status is yellow and orange is unavailable.
    You can configure chart/table views to reflect reverse value severity. For metrics where low values are bad and high values are good, set Green highest and Red lowest. To omit a severity level, set the threshold value to zero. For example, setting Orange to zero removes the major severity when profiling metric thresholds.
  5. Select the
    Max Rows
    . This limit defines the total number of rows that the table can display. If the number of results exceeds the max rows, the table shows the top metrics according to the sorted column.
Configure Table Views
The IM Table (Top) view is a custom view for data from the Data Aggregator data source.
Not all settings are available for all table view types. For standard view configuration details, see Customize Views.
Follow these steps:
  1. Select the
    Metric Fields
    from the selected metric family to display in the table. Each selected field is a column in the table.
    If you select Device Name without Name, the metrics are aggregated to the device level. If you select Name or Description with or without Device Name, the metrics are aggregated to interface or component level.
  2. Select the
    Metric Sort
    , which defines the column to use to sort the table by default.
  3. Select the default
    Sort Direction
    for the
    Metric Sort
    column.
  4. Select a requested resolution. For more information, see Data Resolution.
  5. Select the
    Max Rows
    . This limit defines the total number of rows that the table can display. If the number of results exceeds the max rows, the table shows the top metrics according to the sorted column.