Data explorer

Early Adopter

New

This feature is currently in Early Adopter release.

To try it out

  1. In the Dynatrace navigation menu, select Create custom chart.
    This opens the standard functionality for creating a custom chart.
  2. Click Try it out in the upper-right of the page.
    This opens the Data explorer, which is described below.

The 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.
    Coming soon: analyze events and logs.
  • Choose from any of five visualizations: graph, pie, single value, table, or top list.
    Coming soon: more visualizations, including a heat map and world map.
  • Add your visualization right to your dashboards for easy access and sharing.
  • Provides foundation for metric calculation in charts on dashboards.

Query components and concepts

Every metric query is composed of multiple optional components:

entry fields

query components

Query component Description
Metric name
  • In the UI, select the metric name in the Filter metrics by... 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 AVG, MAX, MIN, SUM, COUNT or MEDIAN. 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.
Grouping By default, a query groups all dimensions using the metric's default aggregation.
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 box and specifying the value, such as selecting Host and then selecting one or more hosts by which to filter your query.

Limitations

  • 5 metrics maximum per chart
  • 20 series per metric

Examples

Table with 2 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 %, AVG, by Host
  • B: Memory used %, AVG, by Host
  • Visualization: Table

Graph with 2 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 %, AVG, by (everything)
  • B: Memory used %, AVG, by (everything)
  • Visualization: Graph
  • Visual settings:
    • A = Area chart
    • B = Line chart

Single value (1st metric only)

  • A: CPU usage %, AVG, by (everything)
  • B: Memory used %, AVG, by (everything)
  • Visualization: Single value

Pie (1st metric only, split)

  • A: CPU usage %, AVG, by Host
  • B: Memory used %, AVG, by (everything)
  • Visualization: Pie

Top list (1st metric only, split)

  • A: CPU usage %, AVG, by Host
  • B: Memory used %, AVG, by (everything)
  • Visualization: Top list