Data explorer

Early Adopter

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.

Quick start

Select Explore data from the navigation menu.
Build a query.
- Select a metric (for example, CPU usage %)
- Choose an aggregation (for example, Average, Minimum, or Maximum)
- Select Split by dimensions
- Specify Filter by criteria
Details
For details on building a query, see Query components and concepts below.
If you want to add another metric, select Add metric and repeat the previous step.
When you have specified your metrics, select Run query to take a first look at the chart.
Use the Settings panel to configure chart settings. The chart is updated with each change.

When you are satisfied with your chart, you can use it within Data explorer immediately or save it to a dashboard for future use.

Use the chart in 'Data explorer'

Chart elements are active. For example:

To see details in tooltips, hover over chart elements
To drill down from a problematic (red) element, select it.
To hide or show a chart element, select the corresponding label in the chart legend

Pin the chart to a dashboard

To save the chart as a dashboard tile, select Pin to dashboard.

To return from the dashboard to Data explorer with the chart open for viewing and editing, open the menu in the upper-right corner of the tile and select View details. Now two buttons are displayed in the upper-right of the Data explorer:

Save changes to dashboard—saves the chart to a same tile and dashboard you used to open the the Data explorer. If you have made any changes, they will update the tile on your dashboard.
Pin to dashboard—saves the chart as a tile on a different dashboard. You might want to pin the same chart (perhaps with filtering differences) to various dashboards.

For details about pinning tiles to dashboards, see Pin tiles to your dashboard.

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

Configuration snapshot

Tile on the dashboard

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