Data explorer

Data explorer greatly enhances your abilities to query and chart metrics.

  • Analyze multidimensional metrics, whether built in to Dynatrace or ingested from StatsD, Prometheus, Telegraf, and others channels.
  • Choose from several visualization types.
  • Add your visualization right to your dashboards for easy access and sharing.
  • Provides a foundation for metric calculation in charts on dashboards.

Quick start

Query components and concepts

Every metric query is composed of multiple optional components:

query entry fields

query components

Query component Description

Metric name

  • In the UI, select the metric name in the Select metric… box.
  • This can be a built-in metric or a metric ingested from a channel such as StatsD, Prometheus, or Telegraf over our metrics API.

Aggregation

Every metric provides the same possible aggregations, which can be specified when selecting Average, Count, Maximum, Minimum, Sum, Median, Percentile 10th, Percentile 75th, or Percentile 90th.

The aggregation enables you to specify how the results of a metric query are supposed to be aggregated over time and the reported dimensions of the selected metric.

The query will always provide the statistically most accurate results for a given query, even if certain metrics provide different statistics, which depends on the nature of each metric.

Splitting

By default, a query does not split by any dimensions using the metric's aggregation. When splitting by a dimension such as host, the aggregation is used for each host.

Scope

The scope is determined by any filter you set.

  • By default, the scope is (include all).
  • You can filter your query by selecting one of the options in the Filter by box and specifying the value, such as selecting Host and then selecting an attribute such as name, tag, or ID. You can add multiple filters.

Limitations

  • 5 metrics maximum per chart
  • 100 series per metric

Examples

Table with two metrics (split)

In this example, we select metrics CPU usage % and Memory used %, break it down by host for both, and display it as a table, so that the rows are hosts and the columns show the metric values per host.

  • A: CPU usage % (builtin:host.cpu.usage), Average, Split by Host
  • B: Memory used % (builtin:host.mem.usage), Average, Split by Host
  • Visualization: Table

The complete query should look like this:
Query for table with two metrics

Example tile:
example table tile

Graph with two metrics

In this example, we select the same metrics and display them as a graph.

When you set Visualization to Graph, the Visual settings are displayed, where you can select how to graph each metric. In this case, CPU usage % is an area chart (the area between 0 and the value of the metric is filled in) and Memory used % is a line chart (a single line representing the value of the metric over time).

  • A: CPU usage % (builtin:host.cpu.usage), Average, Split by Host
  • B: Memory used % (builtin:host.mem.usage), Average, Split by Host
  • Visualization: Graph
  • Visual settings:
    • A = Area
    • B = Line

The complete query should look like this:
Graph with two metrics

Example tile:
example chart tile

See below to explore other visualization types.

Visual settings

The visual settings determine how each metric is displayed.

Visualization

Dynatrace offers the following visualization types.

Graph

Shows query results as a graph.

  • A graph can show up to 20 series per metric.

  • Each metric can be displayed as a line, column, or area, and can have its own color palette.

  • Each chart has three threshold color settings and corresponding percentage values.

  • Shows a chart of selected metrics within the query.

Pie

Shows query results as a pie chart.

  • By default, visualizes the first metric in the query.

Single value

Shows query results as a single value charted over time.

  • Shows the first metric of a multi-metric query, and merges all dimensions to a single aggregate.

  • optional Threshold background determines whether the threshold color is reflected in the background color of the tile.

  • optional Display sparkline determines whether the tile displays a sparkline.

Table

Shows a table of selected metrics within the query.

  • Shows a table of selected metrics within the query.

Top list

Shows query results as a top list.

  • By default, visualizes the first metric in the query.

Heatmap

Shows query results as a heatmap.

  • By default, visualizes the first metric in the query.

  • The bucket settings are the number of buckets you want to display on each axis.

Show legend

To show or hide the chart legend, in the Visual settings section, turn Show legend on or off.

Connect gaps

To connect gaps in a chart, in the Visual settings section, turn on Connect gaps.

Rename a metric

You can change the name of a metric as it is displayed on the chart and in the chart legend. The query definition retains the metric's original name.

To rename a metric

  1. In the Visual settings section, select Edit (pen icon) for the metric you want to rename.

  2. Edit the name, and then select the checkmark to save the new name.

Chart mode

To change the chart mode for a metric, in the Visual settings section, set Chart mode to one of the following:

  • Line
  • Column
  • Area

Color palette

To change the color palette for a metric, in the Visual settings section, select a new Color palette.

Entity linking

For better drilldown capabilities, we have added links to entities.

In this example, the visualization was showing a host behaving erratically. We selected it to see details about the host in a pop-up, and we can select the View host button to drill down directly to the Dynatrace page for that host.

drilldown from host on chart

Thresholds

To enhance your visualizations, you can set thresholds that are reflected in your visualization when the thresholds are exceeded. In this example, the red threshold is set to 70% and is reflected in two different example visualizations.

Graph chart example

In this example, everything above 70 percent is displayed with a red background because the red threshold is set to 70.

threshold settings

Single value example

In this example, the text is red because the metric value exceeded the red threshold.

single value threshold

Fold transformations and trendlines

(Applies only to value visualizations such as single value, pie, top list, and table.)

In certain cases, you need to see the last reported value for a metric, not the total aggregate over the time span. To do this, you can change Fold transformation from Total to Last value.

Change fold transformation to Last value

This will help you understand the current state and not the aggregated state over the time period. To also be able to determine if the current state is the common behavior of the time period, you can turn on Show trendline.

Axes

In the Axes section, you can control how the X axis and each Y axis of your graph are displayed.

Name an axis

To name an axis

  1. In the Axes section, find the axis you want to rename.
  2. Select Edit (pen icon) next to the axis name.
  3. Enter a new name and select the checkmark to save the change.
    The axis name is displayed vertically next to a Y axis and horizontally under the X axis.

Hide or show an axis

To hide an axis

  1. In the Axes section, find the axis you want to hide.
  2. Select View (eye icon).
    To unhide the axis, select View again.

Define an axis position

To specify the side of the chart on which to display a Y axis

  1. In the Axes section, find the Y axis you want to move.
  2. Set Position to Left or Right.

Set an axis minimum and maximum

By default, minimum and maximum axis values are set automatically.

To set custom minimum and maximum values for an axis

  1. In the Axes section, find the axis for which you want to define a minimum and maximum.
  2. Change the value of Min, Max from Auto, Auto to a comma-separated pair of values corresponding to the values on the selected axis.

Advanced query editor

To fully utilize the power of the Metrics API v2 queries from within the web UI, switch to the Code tab.

The Code tab enables you to create metric expressions, timeframe shifts, and much more directly in the web UI and, of course, use this power to create vizualizations for your dashboards. Start by checking out metric expression examples.

For Code tab details, see Data explorer Code tab (advanced query editor).

URL sharing

If you are doing analysis in the Data explorer and find some interesting results that you want to share with another authenticated user, or if you want to be able to revisit the same results yourself using a later timeframe

  1. Open the browse menu in the upper-right corner of the Data explorer
    open menu
    and select Share.
    select Share
  2. If you want to share or save the query link with the current timeframe, turn on Use the current timeframe. Otherwise, the shared/saved query link will specify the current query and settings except the timeframe.
  3. Select Copy to copy the link to your clipboard.

Now you can share the link with any other authenticated Dynatrace user and you can keep a copy for your own use.

Sort

By default, results are sorted in descending order based on the aggregation chosen.

To explicitly set the sort order through the query editor

  1. Select the + button.
  2. Select Sort by.
  3. Set Sort by to Ascending or Descending.

Limit

By default, the number of metrics you see if they are split by a dimension is 10.

To explicitly set a limit through the query editor

  1. Select the + button.
  2. Select Limit.
  3. Set Limit to 1, 10, 20, or 100.

Migration from custom charts

If you have created custom charts in the past, your old charts are still supported, but you will now see a small warning icon in the upper-right corner of each custom chart tile on your dashboard. Hover over the warning icon to see an explanation.

To migrate a custom chart to the new Data explorer chart format

  1. Review Migration limitations below.
  2. Display the dashboard containing your custom chart and then select Edit to edit the dashboard.
  3. Select the custom chart and then select Configure custom chart to open it on the Custom chart page.
  4. In the You're missing out on better charts message box, select Preview upgraded chart.
    This loads your custom chart in Data explorer, where you can review and adjust chart settings.
  5. When you are satisfied with the chart appearance, save it to a dashboard.
    • If you no longer need the original chart and you want to replace it with the new (converted) chart on the same dashboard, select Save changes to dashboard.
    • If you want to keep a copy of the original chart for now, select Pin to dashboard to pin the converted chart as a new chart to the same dashboard or another dashboard.

Migration limitations

The chart migration process has the following limitations:

  • While the Data explorer offers more powerful filtering capabilities, it does not support some custom chart filters. When migrating charts, these filters are skipped.
  • The Data explorer does not support some metrics configured before Summer 2019. These metrics have been deprecated for two years and cannot be imported over the API. When migrating custom charts with these metrics to Data explorer, Dynatrace will display an empty Data explorer page.
  • In some cases, a migrated chart configuration can only be viewed on the Code tab and not on the Build tab.