#Offset explorer how to
#Offset explorer code

#Offset explorer code

To fully utilize the power of the Metrics API v2 queries from within the web UI, switch to the Code tab. To be able to determine if the current state is the common behavior of the time period, turn on Show trendline.

If you need to see the last reported value for a metric (rather than an aggregation), select Last value.You can manually override Auto with any of the following: Last value, Average, Count, Maximum, Minimum, Sum, Median, Value, Percentile 10th, Percentile 75th, Percentile 90th.The default fold transformation is Auto, which automatically selects the most appropriate time aggregation based on the metric.The fold transformation combines a data points list (a timeseries: a collection of data points over the time period) into a single data point. (Applies only to value visualizations such as single value, pie, top list, table, and honeycomb.) 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. In this example, the visualization was showing a host behaving erratically. Dynatrace offers the following visualization types:įor better drilldown capabilities, we have added links to entities. The selection of visual settings available depends on the query and visualization type. 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).

#Offset explorer how to

When you set Visualization to Graph, the Visual settings are displayed, where you can select how to graph each metric. In this example, we select the same metrics and display them as a graph. The complete query should look like this:

B: Memory used % ( builtin:), Average, Split by Host.

A: CPU usage % ( builtin:), Average, Split by Host.

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. 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.By default, the scope is (include all).The scope is determined by any filter you set. When splitting by a dimension such as host, the aggregation is used for each host. 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.īy default, a query does not split by any dimensions using the metric's aggregation. 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. This can be a built-in metric or a metric ingested from a channel such as StatsD, Prometheus, or Telegraf over our metrics API.Įvery 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.In the UI, select the metric name in the Select metric… box.