Donut visualization

Latest Dynatrace

When to use a donut visualization

Use a donut visualization:

  • When you have just a few (no more than 5 to 7) clearly distinguishable categories/slices in your data.
  • When you want to save space and combine a single value with a breakdown.

Example

Donut chart example

The above donut chart is based on the following query.

fetch logs
| summarize count(), by:{loglevel}

In the Donut chart options section, Show total is turned on to show the 1.6M value in the center of the donut.

Title

Use this field to add a title. The edit box is displayed at the top of the options panel.

Title edit box

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

Example:

  1. Define variables called Status and Emoji in your dashboard.
  2. Set Title to Current $Emoji status is $Status.
  3. Set Status to Good.
  4. 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.

For a donut chart, the data mapping section includes:

  • Slice—the column of your result that is displayed as a slice of the donut
  • Value—the value to be reflected in the size of a slice

Donut chart options

To learn about options quickly and decide what works best for you, turn options on and off and see the effect immediately on your chart. For example, does it look best with a label or without? Turn that option on and off and see for yourself.

Color palettes

You can select a color palette from the list under Color palettes.

Slice

Set Slice to the unit by which you want to cut up your chart. Slice and Value together determine how to map your query results to your chart.

Value

Set Value to the value that determines the size of slices. Slice and Value together determine how to map your query results to your chart.

Chart

Use Hide labels to display or hide the labels on your chart.

Legend position

Select where to display the visualization legend:

  • Automatic—Dynatrace chooses an appropriate location
  • Hidden—no legend is displayed
  • Bottom—the legend is displayed along the bottom of the visualization
  • Right—the legend is displayed on the right side of the visualization

Total value

To show the total value in the center of a donut visualization, turn on Show total.

Use Relative values (%) to display chart values as absolute values or relative values (percentages of the total).

Merges slices

Use the Merge slices settings to determine how to merge slices in your chart.

  • Absolute

    For example, if you have three slices with the following values:

    • Slice 1: 40
    • Slice 2: 5
    • Slice 3: 5

    If you select Absolute and set Absolute limit to 10, slices 2 and 3 will merge into one group with the label set in Group label.

  • Relative (%)

    For example, if you have three slices with the following values:

    • Slice 1 - 40 (80% of the total)
    • Slice 2 - 5 (10% of the total)
    • Slice 3 - 5 (10% of the total)

    If you select Relative (%) and set Relative limit to 20 (20%), slices 2 and 3 (which are each below the relative value of 20%) will merge into one group with the label set in Group label.

  • Number of slices

    For example, if you have three slices with the following values:

    • Slice 1: 40
    • Slice 2: 5
    • Slice 3: 5

    If you select Number of slices and set Slice limit to 2, the first two slices will be displayed separately and the others will be merged into one group with the label set in Group label.

Add color override

To override the color of a chart item, select Add color override, select the item from the list, and then set Color to the color you want to use for the selected item.

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 sections and notebook tiles 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.

Units and formats

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

  1. Select to edit the visualization tile.

  2. Select the Visual tab.

  3. Select Units and formats.

  4. Select Override.

  5. Select Override

  6. In the dropdown list, select the item for which you want to add a unit override.

    This is a numeric column of the underlying DQL result, so it varies according to the query. For example:

    • A fetch events query returns events. The dropdown list here lets you select a numeric field (such as transfer_size) from the results.
    • A timeseries avg(dt.host.cpu.usage) query returns a single timeseries for avg(dt.host.cpu.usage). That timeseries is then the only selectable option in the list.
  7. Define the override.

    • Default 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.
    • Displayed unit: Once you define a default unit, you can use Displayed unit for conversion. For example, if the DQL result defined your numeric value in the result as Bytes, Displayed unit now offers a suitable list of byte conversions such as Kilobyte and Megabyte. Unlike the Default unit, the Displayed unit is always a numeric conversion.
    • 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.
    • Suffix displays the suffix to display after the unit. To see it in action, enter a string and observe the change in the visualization. When you don't find the unit you're looking for, you can use Suffix to display the desired unit.
  8. Turn on Abbreviate large numbers if you want to display large figures in abbreviated form. For example, 1053 becomes 1.1K.

To reset to defaults (discard override settings for the selected item), select the trash can next to the item.

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

  1. In Dashboards, create a dashboard.

  2. Select and, in the Snippets section of the menu, select Metrics > Chart average CPU across all hosts.

  3. In the section edit panel, select the Visual tab and select Line.

  4. Select Units and formats.

    Select Units and formats

  5. Select Override.

    Select Add Override.

  6. In the dropdown list, select the metric for which you want to add an override. There's only one metric to select in this example.

  7. Define the override for the displayed metric. You can observe your changes in the Y-axis of the chart.

    • Default unit displays Percent (%), which is the default unit for the selected metric. Try a different setting, such as One to instead display the result as a fraction of 1.

    • Displayed unit displays Auto. You can change it to a different unit, such as One to instead display the result as a fraction of 1.

      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(€).

    • Decimals displays the default number of decimal points (degree of precision) to display. To see it in action, change the Decimals selection and observe the change in the visualization.

      For example, change this:

      Decimals setting before

      To this:

      Decimals setting after

    • Suffix displays the optional suffix to display after the unit. To see it in action, enter a string and observe the change in the visualization.

To reset to defaults (discard override settings for the selected metric), select the trash can next to the metric.