Result display tab

NAM Server ► Reports ► DMI ► New report, Result display tab

Use the Result display tab of the DMI section editor to choose from a number of report customizing options.

See New report for an introduction to creating and managing reports.

Set rows filters

Click Set rows filters to define a an expression that will be used to filter out some of the result rows.

The button opens the Expression editing window, in which you define the expression to use when determining whether to show a row in your report. For example, if you don't care about rows where Availability (total) is 90 or more, select the Availability (total) metric on the Data tab and then set a filter for <Availability (total)> < 90 here.

Add new calculated column

Click Add new calculated column to define a calculated result. Use calculated results much like you would use calculated columns in a spreadsheet: based on the information you have in existing columns, use a formula to calculate and display additional information in further columns.

The button opens the New conditional column window, in which you define a column name, an output type, and the expression to use when calculating the result to display in this column. It could be, for example, as simple as the sum of two metrics (<Client bytes> + <Server bytes>) or some more complicated formula.

See Adding calculated results to your reports for a walkthrough of how to add a calculated column to your report.

Table options

If your section is a table, you can use additional options to customize the way report data is displayed.

Show find control

There are several methods of finding subject data faster than browsing through numerous pages of the tabular report. One of them is to use the Find control that is located below the table.

  • Choose Simple to display only the search icon below the table.
  • Choose Full to display the Find box and a list of dimensions and metrics from the selected table.

Show pagination control

If your table has more rows than the defined page size, you can switch between pages using the pagination control.

  • Choose Simple to display a simple list of page ranges.
  • Choose Full to display page numbers and arrows to navigate between pages.

Page size

To define the size of a report table, set Page size to the maximum number of rows to display on each page.

Transpose table

When large values of a DMI dimension are displayed (for example, HTTP header or HTTP request), you can transpose the rows and columns to show the dimension and metric values horizontally (in rows), which may be more readable. To do this, select the Transpose table check box.
The figures below show two versions of the same table, first in the standard view and then with Transpose table selected.

Standard view:

With Transpose table selected:

Table transposition can be especially useful in comparing two or more items. Using the Select top items field on the Data tab, you can control the number of items that are displayed on each page. In conjunction with table transposition, this table view is more legible.

Show

To specify which columns should appear on the report, open the Result display tab and, in the Show column, select an option:

  • Yes  to display the column.
  • No to hide the column.
  • Conditional to display the column only if certain conditions are met. When you select this option, an edit window is opened where you can also define a scripting expression for the condition. See Conditional visibility of report elements.

Dimension/metric name

If you have selected dimensions and metrics already on the Data tab, this column is populated by your selections and there is nothing to do with them on this tab unless you want to assign aliases to them.

In this example, Client site and Availability (total) have been selected on the Data tab. If I want to assign aliases to them (this can be especially useful when the full names are too long for chart labels and table column headers), I can select the icon next to the Dimension/Metric name column header to open a window that manages a mapping between dimension/metric names and any aliases you want to assign to them.

Then I could, for example, map Availability (total) to Availability, and map Client site to Client.

And these aliases (instead of the full names) would be displayed in my tables and charts on this report:

Color rendering

Configure color rendering to define status icon colors and specify how they change when the corresponding metric values meet certain conditions (conditional formatting).

Report with color rendering (status icons) enabled:

To show status icons (, , , ), select a link in the Color rendering column on the Result Display tab and then choose a coloring option from the list.

Color rendering options:

In the Color rendering list, choose Custom, Benchmark, or Benchmark absolute.

Custom

Use this rendering mode to specify threshold levels for a metric, so the status icon color changes when the value of the cell's metric rises to equal or above the threshold value or falls to below the threshold value. You can color status icons for a specific metric based on threshold values for that metric, or you can choose any other metric that will serve as a base for coloring status icons. You can choose only from metrics that define the selected report. 

You can set as many thresholds on the Result Display tab as necessary. Use the  and  buttons to increase or decrease the number of thresholds. Type the threshold values directly into the threshold boxes. You can use unit prefix symbols (such as k or G) or scientific notation (for example, 1e5) in the boxes.

Certain metrics are more meaningful when represented in reversed color order. Use the Reverse threshold icon button to reverse the color coding of a particular threshold. Note that you cannot reverse threshold values, which should always be set in ascending order.

Custom thresholds configuration

Color indicators for metrics indicate how the current value compares to typical conditions and warn of high and low deviations from the norm. DMI enables you to set your own color sequence for selected metrics. To change a color, select it and choose a different color from the list that opens. The available colors are white, green, yellow, orange, and red.

A list with available colors for threshold ranges

Benchmark

In benchmark mode, threshold values are set the same as for custom mode, but they are used differently: a benchmark cell color is determined by dividing one metric value by the other metric value, and then comparing the result with the threshold. You can select two metrics.

Selecting metrics in benchmark mode

Tooltip over cell where Benchmark coloring is used:

Benchmark mode with two metrics selected

Benchmark absolute

In benchmark absolute mode, a benchmark cell color is determined by subtracting the benchmark value from the metric value, and then comparing the result with the threshold.

Tooltips

A tooltip appears when you hover the pointer over a metric value or a status icon. When Color rendering is set to Custom, the tooltip provides information on the metric value and the threshold levels for the displayed status icon.

Tooltip over a cell with custom rendering

A tooltip over a cell with custom rendering

When Color rendering is set to Benchmark, the tooltip shows the measured and benchmark values that were used for comparison and for calculating the color status.

Tooltip over a cell with benchmark rendering:

A tooltip over a cell with benchmark rendering

Use the tooltip metrics list, which you can access by selecting a link in the Tooltip metrics column, to configure the set of metrics that are displayed in the tooltip.

Example tooltip configuration options:

Metric grouping

Reports can show metric columns either separately or grouped by the metric header labels in the report table.

Report with metric column grouping:

A report with column grouping

For more information on metric grouping, see Defining multi-level table headers.

Custom attributes

To customize how particular column should appear on the report, open the Result display tab and select Default in the Custom attributes column for the column you want to customize.

Each column has properties that can be modified to make the report display more legible and user friendly. Whether a property can be modified depends on the value type displayed in that column. For example, display properties for a column containing a string include Maximum length, Left portion percentage, Warp, Find regexp and Print regexp format ; properties for a column containing time include Custom format, Date type, Time type and Append time zone.

Tip

If your report is truncating a dimension when you need to see the whole dimension, adjust the value of Maximum length (and maybe Left portion percentage) for that dimension to make sure truncation doesn't happen.

The following properties can be adjusted for a particular value type.

String

Any metric displayed as a string of alphanumeric characters.

Example metrics: Operation, Client site description, Server name

  • Maximum length
    Specify a maximum number of characters to be displayed inside the column.

  • Left portion percentage
    Define the left portion display of the string. For example, value 20 will display 20% of the left portion of the string.

  • Wrap
    Enable and disable line wrapping of the string inside the column. If set to true, text can be displayed in more than one line.

  • Find regexp
    Enter the regular expression to extract desired data from the string.

  • Print regexp format
    Enter the regular expression to display a specific data from the string. The format is used to print values found by Find regexp.
    Example: There is a number of software service names starting with "EXCHANGE". We want to hide the "EXCHANGE" prefix for all these software service names. In this case, Custom attributes should be configured as follows:

Date

Any metric that displays time or a timestamp.

Example metrics: Time

Example metrics: Operation, Client site description, Server name

  • Custom format
    Enter a custom format for displaying time. DMI uses the patterns available the Java DateTimeFormatter class.
    With a custom date format, you can set your own date patterns. For example, dd/mm/yyyy, mm/dd/yyyy, yyyy-mm-dd.
    You can use the following pattern:
Letter   Date or Time Component   Presentation       Examples
G        Era designator           Text               AD
y        Year                     Year               1996;    96
M        Month in year            Month              July; Jul; 07
w        Week in year             Number             27
W        Week in month            Number             2
D        Day in year              Number             189
d        Day in month             Number             10
F        Day of week in month     Number             2
E        Day in week              Text               Tuesday; Tue
a        Am/pm marker             Text               PM
H        Hour in day (0-23)       Number             0
k        Hour in day (1-24)       Number             24
K        Hour in am/pm (0-11)     Number             0
h        Hour in am/pm (1-12)     Number             12
m        Minute in hour           Number             30
s        Second in minute         Number             55
S        Millisecond              Number             978
z        Time zone                General time zone  Pacific Standard Time; PST; GMT-08:00
Z        Time zone                RFC 822 time zone  -0800

(from Java API doc)
  • Date type
    Select the date display format. Available options are none, M/d/yy, M/yy and M/d
  • Time type
    Similar to Date type, select the time display format. Available options are none, HH:mm, HH:mm:ss, HH:mm:ss:SSS
  • Append time zone
    Indicate the time zone of the metric. Available options are none, always, smart

Number

Any metric that displays an integer as a number or percentage

Example metrics: Application performance, Percentage of network time

  • Format
    Specify the metric display format. For example: ##.##

    The format is used to print values. For example: # ##0.0000, 0.00, 0.####, 0.0000E0. See the documentation of Decimal Format in Java documentation for all available options.

Period

All metrics that represent a specific period in time.

Example metrics: Server time, Network time, Operation time

  • Unit
    Scale the displayed unit. Available scales are based on default metric units.
    You can choose a fixed unit or smart mode. Smart mode means that a period ( .) is displayed in units such as hours, minutes, seconds. You can limit the number of units visible through the Units shown in smart mode attribute.
  • Units shown in smart mode
    Limit the number of units shown if the unit is set to smart mode.
  • Number format in fixed mode
    Specify the format of a value displayed in selected units.
    If the unit is not set to smart mode, you can set the format (precision) of displayed values. For example: # ##0.0000, 0.00, 0.####, 0.0000E0. See the documentation for Decimal Format in Java documentation for all available options.

Load

All metrics that load.

Example metrics: Hits, Operations, Total packets

  • Unit
    Scale the displayed unit. Available scales are based on default metric units.
  • Number format in fixed mode
    Specify the format of a value displayed in using selected units. For example: 0.000000.

Breakdown

All metrics that display a breakdown of aggregated metrics.

Example metrics: Operation time breakdown

  • Bar color
    Select a color of the displayed bar.
  • Unit
    Scale the displayed unit. Available scales are based on default metric units.
  • Number format in fixed mode
    Specify the format of a value displayed in using selected units. For example: 0.000000.