Single value visualization

Latest Dynatrace
How-to guide
2-min read

When to use a single value visualization

Use a single value visualization when you want to:

Show a single aggregated measurement and its trend over time.
Express important business-related Key Performance Indicators (KPIs).
Express infrastructure-related critical Service Level Objectives (SLOs).

Examples

Example 1 - DQL-based single value

Single value example

The visualization above is based on the following query.

timeseries sparkline=avg(dt.host.cpu.usage)
| fieldsAdd value=arrayAvg(sparkline)

In this example, the chart option selections included:

Record field: value
Alignment: Center
Show trend: On
Trend value: Relative
Show sparkline: On
Sparkline: sparkline

Example 2 - Code-based single value

Single value chart example

Example code

/*
 * This example shows how to map data to use the built-in visualization for custom data.
 */

export default async function () {
  return {
    records: [
      {
        value: 'CPU usage',
        interval: '60000000000',
        timeframe: {
          start: '2023-11-13T07:24:00.000Z',
          end: '2023-11-13T09:25:00.000Z',
        },
        series: [1832, 997, 432, 997, 2343, 997, 544, 997, 234],
      },
    ],
    types: [
      {
        mappings: {
          value: {
            type: 'string',
          },
          interval: {
            type: 'duration',
          },
          timeframe: {
            type: 'timeframe',
          },
          series: {
            type: 'array',
            types: [
              {
                mappings: {
                  element: {
                    type: 'double',
                  },
                },
                indexRange: [0, 120],
              },
            ],
          },
        },
        indexRange: [0, 0],
      },
    ],
  };
}

In this example, the chart option selections included:

Record field: value
Alignment: Center
Icon: Codeicon
Show trend: On
Trend value: Relative
Show sparkline: On

Example 3 - Single value grid

Example single value with grid

The visualization above is based on the following query.

timeseries sparkline=avg(dt.host.cpu.usage), value=avg(dt.host.cpu.usage, scalar:true), by:{dt.entity.host}
| fieldsAdd name=entityName(dt.entity.host)
| sort arrayAvg(value), direction:"descending"
| limit 5

In this example, the chart option selections included:

Record field: value
Show label: Data > name
Alignment: Center
Show trend: On
Trend value: Relative
Show sparkline: On
Sparkline: sparkline

Chart interactions

Selection interactions

When you select a value on a chart and pin the displayed tooltip open, you can then hover over the tooltip to display a menu of selection-specific options.

The chart interactions available to you depend on your query and visualization. For example, if you select a host on a line chart and hover over the tooltip, you will see a menu of items such as:

Copy name—copy the name of the selected host.
Fields—a section with a submenu for each query field. A field submenu offers field-specific options such as:
- Copy value—copy the value of the field. Also displays the field type.
- Hide—hide the field in the chart.
- Explain value—use AI to explain the field.
- Add command to query—a section of field-specific commands that you can automatically add to your query.
- A recommended app may also be listed.
Visual options—opens the edit panel so you can change visualization options for the selected item.
Set color—opens the edit panel so you can change the color of the selected item.
Go to host—opens the selection in Infrastructure & Operations.

In general, if there are recommended apps to open the selected item, the menu offers direct links to those apps, followed by an Open with option to select a different target app.
Open with—for details, see Drilldowns and navigation.

Title

Use the title field at the top of the options panel (initially Untitled tile or Untitled section) to add a title to your dashboard tile or notebook section.

You can use emojis such as 😃 and 🌍 and ❤️.
You can use variables.

Example:

Define variables called Status and Emoji in your dashboard.
Set the title to Current $Emoji status is $Status.
Set Status to Good.
Set Emoji to 🌍.

The title will be displayed as Current 🌍 status is Good.

Visualization

If you aren't sure that you chose the right visualization, use the visualization selector to try different visualizations.

Data mapping

The data mapping section shows how a column of your result is mapped to the visualization.

Expand for general rules on data mapping settings

Expand the Data mapping section of your visualization settings to see how data in your result is mapped to your visualization, and to adjust those settings if needed.

Mandatory fields are marked with an asterisk (*). Example:

Example data mapping: line chart
Data types are displayed next to field names in dropdowns and mapped fields.
Units are displayed when there’s only one assigned.
Result fields are grouped into Suitable and Unsuitable. Fields are marked as unsuitable if they cannot be used to display data in the visualization. Example:

Example data mapping: line chart, Time dropdown
Automatic application of data mapping default settings:

Dynatrace version 1.319+
- Already existing tiles and sections are considered to be user-defined. Their data mapping configurations aren't updated automatically.
- Newly created tiles and sections apply a data mapping setting by default. If you don't modify these settings manually, these settings might change if a new execution of the tile/section modifies the results and there are fields missing or new fields that better suit the data mapping.

Visualization-specific data mapping settings

For a single-value chart, the data mapping section includes:

Single value: the column of your result that is displayed in the single value visualization.
Sparkline: the value to be reflected in a sparkline in the single value visualization. This also affects the trend, which is calculated as the difference between the first and last elements of the timeseries selected as a sparkline.
Interval: this value is automatically mapped and can’t be changed. It lets you know which fields are mapped for timeseries-based results. It takes the first available interval field from the result set whenever a timeseries is used (also includes any makeTimeseries-based data).
Trend: Select Auto to automatically calculate the trend based on the data provided for the sparkline. Select Custom to choose a numeric field.

Grid view

When the result consists of multiple rows:

Previously, only the last result was shown in a single value visualization.
Since Dynatrace version 1.324, the single value visualization automatically switches to a grid view, with each value displayed as a separate single value. The maximum number of values displayed in the grid is 25.

Advantages:

Improves transparency and prevents potentially misleading interpretations.
No need for multiple visualizations of related results. All data is displayed in a consistent format on a single grid.

If you prefer the previous behavior (without the grid), you can apply a DQL limit and a sort command using DQL or the Explore interface.

Single value

Use these options to specify the general display options of your visualization.

Show label specifies the label to display on the visualization.
- None displays no label.
- Custom displays the label you enter in the edit box.
- Data displays the selection you make in the Select an option list.
Apply threshold color to:
- Value colors the value.
- Background colors the background.
Align value sets the alignment of the displayed value to left, center, or right.
Show icon specifies the icon to display before the value.

Trend

To turn the trend on and off, use the switch in the upper right. If it's turned on:

Show label displays the label you enter in the edit box.
Representation displays an absolute or relative value.
Colors sets the colors for an up, horizontal, and down trend.
- Trend value specifies whether to show an absolute or percentage trend value.

Sparkline

To turn the sparkline on and off, use the switch in the upper right. If it's turned on:

Variant displays the sparkline in area, line, or bar format.
Sparkline color specifies the color of the sparkline.
Scale values specifies linear or log scaling.
Color sets the sparkline color.
Show ticks specifies whether to display values along the X-axis.
Record field specifies the record field to display as a sparkline on the visualization.
Min value sets the minimum value in the data.
- Auto selects a suitable minimum based on data (0 or min value).
- Custom lets you set a manual minimum value.
Max value sets the minimum value in the data.
- Auto selects a suitable maximum based on data (0 or max value).
- Custom lets you set a manual maximum value.

Colors

The color settings for a visualization are displayed in rows.

Each row associates a color scheme with a condition/value related to a selected field displayed in the visualization.

To adjust the settings for a row, there are two menus of settings that will be used in combination to determine which color is displayed:

The first menu in a row displays the selected color or color palette. Open this menu to display three tabs of color options:
- Palettes: select a color palette to use for this row.
  Palette exceptions for certain visualization types
  Heatmap and honeycomb: the palette only applies the first color (unless color rules match the data mapping values or Name is used), and the palette is not reflected in the legend.
  Categorical: the nth color in the palette is applied to the nth item in the series.
  Categorical for multiple subcategories: palettes are by bin but are not reflected in the legend.
  Table: palettes are not applicable to tables.
- Colors: select a color to apply uniformly when this rule matches.
- Custom: specify a precise hex color code (for example, #134FC9) or use the color picker to select a color visually.
The second menu in a row displays the condition under which this row's color will be displayed. Select the current setting to change the field, operator, and value as needed to evaluate the condition.
- The fields available for evaluation depend on the raw data.
  - Name is a special property constructed via the Data mapping setting Names.
  - Value is a special property constructed via the Data mapping setting Values (heatmap visualization only).
- The available operators change to suit the conditon being evaluated.

Colors: additional actions

To add a row, select and configure it as described above.
To move a row up or down in the table, select and drag .
opens a menu of further options:
- Move up and Move down move the row up or down one row. These are alternatives to .
  
  Remember that colors are applied in the order in which they are listed in the Colors section, from top to bottom, so changing the order may give you different results.
- Duplicate creates a copy of the selected row.
- Delete section removes the row. You can delete all color rules for table and single value visualizations; all other visualizations need at least one color rule.

Colors: Examples:

Pie

In this pie visualization example, we have applied:

Green to slices with values below 15.
Yellow to slices with values at or above 15.
Red to slices with values at or above 20.

If you changed the order of the rows in the Colors section, you would see different colors. For example, if you swapped rows 2 and 3 above, all slices with values at or above 20 would be colored red, but then all slices with values at or above 15, including all the red slices, would be colored yellow.

Example pie visualization with coloring applied

Honeycomb

In this honeycomb visualization example, we have applied:

Green to all value.A values.
Yellow as a row marker (on the left) for value.A values at or above 15.
Red to the entire row for value.A values at or above 20,

The result is a fully thresholded honeycomb chart. You can use other honeycomb visualization settings to adjust the labels, tooltip, legend, and so on.

Example honeycomb visualization with coloring applied

Units and formats

To override the default units and formats in a dashboard or notebook visualization

Select to edit the visualization tile.
Select the Visual tab.
Expand Units and formats.

The Units and formats section lists all available unit settings for the document (dashboard or notebook). Some units may already be added automatically when querying metrics from their metadata.

Each row has two menus:
- The left menu displays unit settings.
- The right menu displays field mapped to that unit.
Example rows in "Units and formats" settings
To edit unit settings, open the left menu and review/set the following settings:
- Unit: The base unit in which the values were captured. It's None if it was not included in the DQL result, or its automatically defined by the unit passed from the DQL result. This field doesn't lead to any conversion but modifies the suffix to correspond to the unit.
- Convert: You can turn on Convert for conversion. For example, if the DQL result defined your numeric value in the result as Bytes, Convert now offers a suitable list of byte conversions such as Kilobyte and Megabyte.
  
  Only linear and static conversions are supported. For example, you cannot convert Degree Celsius(°C) into Degree Fahrenheit(°F), or convert Usd(US$) into Eur(€).
The Format section determines how the unit is displayed:
- Decimals: displays the default number of decimals (degree of precision) to display. To see it in action, change the Decimals selection and observe the change in the visualization.
- Custom suffix: displays the suffix to display after the unit. To see it in action, turn on Custom suffix, enter a string, and observe the change in the visualization. When you don't find the unit you're looking for, you can use Custom suffix to display the desired unit.
- Abbreviate large numbers: displays large figures in abbreviated form,. For example, 1053 becomes 1.1K.
- Multiple units: displays more than one unit. Turn this on and select the number of units to display. For example, 90 seconds becomes 1m 30s if multiple units is enabled and 2 units are selected.
To choose a different field for a row, open the right menu in that row and select a field from the available fields.

Units and formats: Additional actions

To add a row, select (Add) and configure it as described above.
(Actions) opens a menu of further options:
- Duplicate creates a copy of the selected row.
- Delete removes the row.
- Reset resets the settings in the selected row to default/metadata values.

Units and formats: Examples

Chart average CPU across all hosts

This example uses a line chart, but the options apply to other visualizations.

In Dashboards, create a dashboard.
Select and, in the Library section of the menu, select Chart average CPU across all hosts.
In the edit panel, select the Visual tab and select Line.
Expand Units and formats.

One row is already defined based on metadata from avg(dt.host.cpu.usage).
To override the unit settings for that field, open the left menu in that row to display the unit settings.
Define an override for the displayed metric. You can observe your changes in the Y-axis of the chart.
- Unit displays Percent, which is the default unit for the selected metric.
- Turn on Convert to try conversions settings. For example, change Auto to One to display the result as a fraction of 1.
- Decimals displays the default number of decimal points (degree of precision) to display. For example, enter Pct and review the dashboard to see Pct instead of % displayed after the percentage value.
- Turn on Custom suffix to try different suffixes to display after the unit. For example, change the Decimals selection and review the dashboard to see the change in the number of decimal points in the percentage value.

To reset to defaults (discard override settings for the selected metric), open the (Actions) menu for that row and select Reset.

Query limits

Use the Query limits section to check and adjust the Grail query limits per notebook section or dashboard tile. These settings determine the maximum limits when fetching data. Exceeding any limit will generate a warning.

Dashboard tiles and notebook sections created in Dynatrace earlier than version 1.296 are not affected. Those existing tiles/sections will return the same results as before.

Read data limit (GB)

The limit in gigabytes for the amount of data that will be scanned during a read.
Record limit

The maximum number of result records that this query will return. Default: 1,000 records. To see more records, you need to increase the value of Record limit.
If your query has no limit, such as

fetch logs

the value of Record limit is applied. By default, you will see up to 1,000 records.

If your query also includes a limit, such as

fetch logs
| limit 2000

the lower of the two values (either limit in your query, or Record limit in the web UI) is applied.

In the example above, you would still see only 1,000 records unless you increased the value of Record limit.
Result size limit

The maximum number of result bytes that this query will return. For better performance with typical queries and smaller documents, the default is set to 1 MB.
Sampling (Logs and Spans only)

Results in the selection of a subset of Log or Span records.